Data Catalogue¶
The CABD data catalogue contains the the information you need to make sense of the attributes for each CABD feature type (dams, waterfalls, fishways, stream crossings and modelled stream crossings), including human-readable field names, breakdowns of allowable field values, and definitions. If you have questions about any of the information on this page, you can reach out to us at cabd@cwf-fcf.org.
Feature Types¶
| Name | Version |
|---|---|
| Dams | 1.2 |
| Fishways | 1.1 |
| Modelled Crossings | 1.0 |
| Stream crossings | 1.0 |
| Waterfalls | 1.1 |
Dams
- Definition
A dam is a structure that is constructed to divert or hold back water of a stream, river, or lake for a specific purpose, e.g., hydroelectricity, water storage, or flood control. These structures impede the ability of fish to travel upstream unless there is a fishway installed on the structure. In the CABD, dams are defined as: small dams (i.e., having a height of less than 5 m), medium dams (i.e., having a height between 5 and 15 m), and large dams (i.e., having height of 15 m or greater, or a height between 5 m and 15 m that impounds more than 3 million m3).
Currently, the CABD dams layer also includes other types of structures, including weirs, powerhouses, spillways, canals, and lateral structures (e.g., embankments or saddle dams). Some of these structures don’t necessarily fragment freshwater systems in the upstream-downstream plane. As such, these structures should not be used for connectivity network analyses or barrier prioritization exercises. These data points can be filtered out using the Used for Network Analysis field (``use_analysis = false`` in the data).- Attributes
Addressed Status, Addressed Status Code, Assessment Schedule, Assessment Type, Assessment Type Code, Average Rate of Discharge (L/s), Barrier Assessment Status, Barrier Assessment Status Code, Barrier Identifier, Barrier Removed, Barrier Removed Status Code, Comments, Completeness Level, Completeness Level Code, Construction Material, Construction Material Code, Construction Year, Dam Condition, Dam Condition Code, Dam Function, Dam Function Code, Dam Name (English), Dam Name (French), Dam Size, Dam Size Class Code, Dam Use, Dam Use Code, Degree of Regulation, Downstream Passage Route, Downstream Passage Route Code, Expected End of Life, Facility Name (English), Facility Name (French), Feature Data Source Details, Feature Type, Federal Compliance Status, Federal Flow Requirements (m3/s), Generating Capacity (MWh), Has Hydro Peaking System, Height (m), Include in ACT, Lake Control, Lake Control Code, Last Maintenance Date, Last Modified, Latitude, Length (m), Location, Longitude, Municipality, NHN Watershed ID, NHN Watershed Name, Next Maintenance Date, Number of Turbines, Operating Note, Operating Status, Operating Status Code, Owner, Ownership Type, Ownership Type Code, Passability Status, Passability Status Code, Passability Status Note, Province/Territory Code, Province/Territory Name, Provincial Compliance Status, Provincial Flow Requirements (m3/s), Reservoir Area (km2), Reservoir Depth (m), Reservoir Name (English), Reservoir Name (French), Reservoir Present, Spillway Capacity, Spillway Type, Spillway Type Code, Storage Capacity (mcm), Structure Type, Structure Type Code, Turbine Type, Turbine Type Code, Updates Pending, Upstream Catchment Area (km2), Upstream Linear Length (km), Upstream Passage Type, Upstream Passage Type Code, Use Fisheries, Use Fisheries Code, Use Flood Control, Use Flood Control Code, Use Hydroelectricity, Use Hydroelectricity Code, Use Invasive Species Control, Use Invasive Species Control Code, Use Irrigation, Use Irrigation Code, Use Navigation, Use Navigation Code, Use Other, Use Other Code, Use Pollution Control, Use Pollution Control Code, Use Recreation, Use Recreation Code, Use Water Supply, Use Water Supply Code, Use Wildlife Conservation, Use Wildlife Conservation Code, Use for Network Analysis, Waterbody Name (English), Waterbody Name (French), Year Removed
Fishways
- Definition
A structure that is constructed to facilitate the passage of fish up- and/or downstream of an aquatic barrier (e.g., a dam or waterfall).
- Attributes
Architect, Attraction Estimate (%), Average Velocity of Water Flow (m/s), Completeness Level, Completeness Level Code, Constructed By, Contracted By, Dam Identifier, Designed Based on Biology, Elevation (m), Engineering Notes, Entrance Location, Entrance Location Code, Entrance Position, Entrance Position Code, Feature Data Source Details, Feature Type, Fishway Type, Fishway Type Code, Gradient, Has Evaluating Studies, Is Modified, Latitude, Length (m), Location, Longitude, Maximum Velocity of Water Flow (m/s), Mean channel depth (m), Modification Purpose, Modification Year, Monitoring Equipment, Municipality, NHN Watershed ID, NHN Watershed Name, Nature of Evaluation Studies, Operated By, Operation Notes, Operation Period, Plans Held By, Province/Territory Code, Province/Territory Name, Purpose of Fishway, Reference Identifier, River/Stream Name (English), River/Stream Name (French), Species Known To Not Use, Species Known To Use, Structure Name (English), Structure Name (French), System Identifier, Transit Success Estimate (%), Updates Pending, Waterbody Name (English), Waterbody Name (French), Year Constructed
Modelled Crossings
- Definition
Modelled stream crossings based on locations where a stream is crossed by a road, railway, or trail.
- Attributes
Addressed Status, Addressed Status Code, Assessment Type, Assessment Type Code, Barrier Identifier, Comments, Crossing Addressed, Crossing Confirmed, Crossing Subtype, Crossing Subtype Code, Crossing Type, Crossing Type Code, Crossing Type Source, Feature Type, Latitude, Location, Longitude, Municipality, NHN Watershed ID, NHN Watershed Name, Passability Status, Passability Status Code, Province/Territory Code, Province/Territory Name, Railway Operator, Railway Status, Roadway Type, Stream Name, Stream Order, Transport Feature Name, Transport Feature Owner, Transport Feature Type, Use for Network Analysis
Stream crossings
- Definition
A stream crossing is a location where a stream is crossed by a road, railway, pipeline, or any other infrastructure which might restrict the flow of the stream in ordinary or flood conditions.
- Attributes
Addressed Status, Addressed Status Code, Alignment, Alignment Code, Assessment Source, Assessment Type, Assessment Type Code, Barrier Assessment Status, Barrier Assessment Status Code, Barrier Identifier, Barrier Removed, Barrier Removed Status Code, Constriction, Constriction Code, Crossing Comments, Crossing Condition, Crossing Condition Code, Crossing Type, Crossing Type Code, Date Observed, Downstream Bankfull Width (m), Downstream Bankfull Width Confidence, Downstream Bankfull Width Confidence Code, Downstream Channel Depth (m), Downstream Channel Width (m), Downstream Scour Pool Width (m), Downstream Tidal Range (m), Feature Type, Flow Condition, Flow Condition Code, Include in ACT, Latitude, Lead Observer, Location, Location Description, Longitude, Low Tide Prediction, Municipality, NHN Watershed ID, NHN Watershed Name, Number of Railway Tracks, Original Assessment ID, Passability Status, Passability Status Code, Photo Id Downstream, Photo Id Inlet, Photo Id Other, Photo Id Outlet, Photo Id Upstream, Province/Territory Code, Province/Territory Name, Railway Operator, Railway Status, Road Class, Road Fill Height (m), Road Flooded at High Tide, Road Name, Road Surface, Road Type, Road Type Code, Salinity (ppt), Site Type, Site Type Code, Strahler Order, Stream Name, Stream Type, Stream Type Code, Structure Count, Tailwater Scour Pool, Tailwater Scour Pool Code, Tide Stage, Tide Stage Code, Tide Station, Transport Feature Owner, Upstream Bankfull Width (m), Upstream Bankfull Width Confidence, Upstream Bankfull Width Confidence Code, Upstream Channel Depth (m), Upstream Channel Width (m), Upstream Scour Pool Width (m), Upstream Tidal Range (m), Vegetation Change, Vegetation Change Code, Visible Utilities, Visible Utilities Code
Waterfalls
- Definition
A natural structure that may impede the ability of fish to travel upstream due to changes in elevation and increased flow velocity.
- Attributes
Barrier Identifier, Comments, Completeness Level, Completeness Level Code, Fall Height (m), Fall Name (English), Fall Name (French), Feature Data Source Details, Feature Type, Include in ACT, Last Modified, Latitude, Location, Longitude, Municipality, NHN Watershed ID, NHN Watershed Name, Passability Status, Passability Status Code, Province/Territory Code, Province/Territory Name, Updates Pending, Use for Network Analysis, Waterbody Name (English), Waterbody Name (French)
Dams Attributes
Addressed Status
Feature Type: Dams
Definition: Indicates whether the crossing has been rehabilitated in some way to improve fish passage.
Field Name: addressed_status
Data Type: varchar(64)
Addressed Status Code
Feature Type: Dams
Definition: Indicates whether the crossing has been rehabilitated in some way to improve fish passage.
Field Name: addressed_status_code
Data Type: integer
Code Name Description 1 Decommissioned/ Removed The crossing has been decommissioned or removed. 2 Replaced The crossing has been replaced with a fully passable structure. 3 Fish Ladder A fish ladder has been added to the crossing to improve fish passage. 4 Baffling Baffling has been installed at the crossing to reduce water velocity and provide resting areas for fish. 5 Backwatering Backwatering has been added at the crossing to reduce water velocity and turbulence and raise water levels. 6 Other The crossing has been addressed in some way to improve fish passage, but the measure is different than those defined in this table. 99 Unknown It is unknown whether the crossing has been addressed to improve fish passage.
Assessment Schedule
Feature Type: Dams
Definition: Frequency at which the dam structure is assessed by ownership party or regulatory body.
Field Name: assess_schedule
Shapefile Field Name: assess_sch
Data Type: varchar(100)
Assessment Type
Feature Type: Dams
Definition: The type of assessment carried out at the stream crossing.
Field Name: assessment_type
Data Type: varchar(64)
Assessment Type Code
Feature Type: Dams
Definition: The type of assessment carried out at the stream crossing.
Field Name: assessment_type_code
Data Type: integer
Code Name Description 1 Rapid A rapid assessment has been conducted at the crossing. 2 Full A full assessment has been conducted at the crossing. 3 Other An assessment has been conducted at the crossing, but the type of assessment is different than those defined in this table. 4 Imagery The crossing has been reviewed through available satellite imagery, but has not been visited in the field. 5 Modelled The crossing has not been visited in the field or reviewed in satellite imagery. 6 Inventory The feature is updated from existing inventories that contain data that cannot be considered assessment data
Average Rate of Discharge (L/s)
Feature Type: Dams
Definition: Average rate of discharge at dam location in liters per second.
Field Name: avg_rate_of_discharge_ls
Shapefile Field Name: avg_dis_ls
Data Type: double
Barrier Assessment Status
Feature Type: Dams
Definition: Indicates whether the barrier has been assessed.
Field Name: barrier_assessment_status
Data Type: varchar(64)
Barrier Assessment Status Code
Feature Type: Dams
Definition: Indicates whether the barrier has been assessed.
Field Name: barrier_assessment_status_code
Data Type: integer
Code Name Description 1 assessed 2 not assessed
Barrier Identifier
Feature Type: Dams
Definition: Unique Identifier for dam.
Field Name: cabd_id
Shapefile Field Name: cabd_id
Data Type: uuid
Barrier Removed
Feature Type: Dams
Definition: Indicates whether the barrier has been removed or decommissioned.
Field Name: barrier_removed
Data Type: varchar(64)
Barrier Removed Status Code
Feature Type: Dams
Definition: Indicates whether the barrier has been removed or decommissioned.
Field Name: barrier_removed_code
Data Type: integer
Code Name Description 1 yes 2 no 99 unknown
Comments
Feature Type: Dams
Definition: Unstructured comments about the dam.
Field Name: comments
Shapefile Field Name: comments
Data Type: text
Completeness Level
Feature Type: Dams
Definition: The level of information available for the dam in the CABD.
Field Name: complete_level
Shapefile Field Name: comp_lvl
Data Type: varchar(32)
Completeness Level Code
Feature Type: Dams
Definition: The level of information available for the dam in the CABD.
Field Name: complete_level_code
Shapefile Field Name: complvl_c
Data Type: integer
Code Name Description 1 Unverified Record is not verified. 2 Minimal Record is verified but little attribute data is captured. 3 Moderate Record is verified and most attribute data is captured. 4 Complete Record is verified and all attribute data is captured.
Construction Material
Feature Type: Dams
Definition: The primary construction material of the structure.
Field Name: construction_material
Shapefile Field Name: const_mat
Data Type: varchar(32)
Construction Material Code
Feature Type: Dams
Definition: The primary construction material of the structure.
Field Name: construction_material_code
Shapefile Field Name: constmat_c
Data Type: integer
Code Name Description 1 Concrete 2 Masonry 3 Earth 4 Rock 5 Timber 6 Steel 7 Other 99 Unknown
Construction Year
Feature Type: Dams
Definition: Year in which the dam was built (not further specified: year of construction; year of completion; year of commissioning; year of refurbishment/update; etc.)
Field Name: construction_year
Shapefile Field Name: const_yr
Data Type: integer
Dam Condition
Feature Type: Dams
Definition: The dam's physical condition.
Field Name: dam_condition
Shapefile Field Name: damcond
Data Type: varchar(32)
Dam Condition Code
Feature Type: Dams
Definition: The dam's physical condition.
Field Name: condition_code
Shapefile Field Name: damcond_c
Data Type: integer
Code Name Description 1 Good Structure is fit for its intended purpose; not damaged and capable of agreed standard of performance. 2 Fair Structure is in average condition, possessing minor defects. 3 Poor Structure condition is deteriorated and requires maintenance. 4 Unreliable Structure is not suitable for its intended purpose.
Dam Function
Feature Type: Dams
Definition: The intended function of the dam.
Field Name: function_name
Shapefile Field Name: dam_func
Data Type: varchar(64)
Dam Function Code
Feature Type: Dams
Definition: The intended function of the dam.
Field Name: function_code
Shapefile Field Name: damfunc_c
Data Type: integer
Code Name Description 1 Storage A structure built to store water for a variety of purposes (e.g., water supply, irrigation, pollution control, etc.). 2 Diversion A structure built to divert all or some water from a waterway, often into a man-made canal or conduit. 3 Detention A structure built for flood control. Retains excess water in a reservoir to maintain the carrying capacity of the waterway, releasing it gradually at a controlled rate to protect downstream areas from flooding. 4 Saddle An auxiliary structure constructed at low spots along the perimeter of a reservoir to limit its extent, or to allow for an increase in storage capacity. 5 Hydro - Closed-cycle pumped storage A structure that is part of a facility configured to pump water between two water reservoirs at different elevations; both reservoirs are isolated from a free-flowing water source. 6 Hydro - Conventional storage A structure that is part of a facility that impounds water, which when released, flows through a turbine and generates electricity. 7 Hydro - Open-cycle pumped storage A structure that is part of a facility configured to pump water between two water reservoirs at different elevations; a free-flowing water source is used for either the upper or lower reservoir. 8 Hydro - Run-of-river A structure that is part of a facility that channels or syphons water from a water source through an intake and into a canal or penstock to spin a turbine. 9 Hydro - Tidal A structure that is part of a facility configured to intake and store water during high tide and slowly release it back into the ocean during low tide. 10 Hydro - Other A structure that is part of a facility used to generate hydroelectricity, whose process for generating power is unknown or different than those defined in this table. 11 Other The function of the structure is known, but is different from those defined in this table (e.g., debris control or cofferdams). Occasionally, some lateral structures (e.g., canals, embankments, and dikes) may serve a specific function other than those defined in this table and should be assigned a dam function of ‘other’. 99 Unknown The function of the structure is unknown.
Dam Name (English)
Feature Type: Dams
Definition: Given or known name of the dam structure, English.
Field Name: dam_name_en
Shapefile Field Name: damname_en
Data Type: varchar(512)
Dam Name (French)
Feature Type: Dams
Definition: Given or known name of the dam structure, French.
Field Name: dam_name_fr
Shapefile Field Name: damname_fr
Data Type: varchar(512)
Dam Size
Feature Type: Dams
Definition: The size category of the dam based on the height of the dam in meters.
Field Name: size_class
Shapefile Field Name: damsize
Data Type: varchar(32)
Dam Size Class Code
Feature Type: Dams
Definition: The size category of the dam based on the height of the dam in meters.
Field Name: size_class_code
Shapefile Field Name: damsize_c
Data Type: integer
Code Name Description 1 Small A dam having a height less than 5 m. 2 Medium A dam having a height between 5 and 15 m. 3 Large A dam having a height of 15 m or greater, or a height between 5 m and 15 m that impounds more than 3 million m3. 99 Unknown Unknown size
Dam Use
Feature Type: Dams
Definition: The primary use of the dam.
Field Name: dam_use
Shapefile Field Name: dam_use
Data Type: varchar(32)
Dam Use Code
Feature Type: Dams
Definition: The primary use of the dam.
Field Name: use_code
Shapefile Field Name: damuse__c
Data Type: integer
Code Name Description 1 Irrigation Supplies controlled amounts of water to land or crops in needed intervals. 2 Hydroelectricity Generates electricity by passing water through a hydraulic turbine. 3 Water supply Water stored for municipal use. 4 Flood control Reduces the effects of flood waters or high-water levels on downstream areas. 5 Recreation Reservoir allows for recreational activities (e.g., swimming, boating, fishing etc.). 6 Navigation Increases water levels on rivers to permit ship to navigate waters that were previously unnavigable. 7 Fisheries Increasing water levels of the reservoir during spawning season creates suitable spawning habitat for fish, enhancing fish production and fishing success of anglers. 8 Pollution control Protects the water resource by trapping polluted water in reservoirs or ponds. 9 Invasive species control Prevents the spread of invasive species upstream or to environmentally sensitive areas within the waterway. 10 Wildlife Conservation Regulates the flow of water for the purposes of wildlife conservation (e.g., waterfowl habitat). 11 Other The intended use of the dam cannot be defined by the use categories defined in this table. 99 Unknown The intended use of the dam is unknown.
Degree of Regulation
Feature Type: Dams
Definition: Degree of Regulation (DOR) in percent; equivalent to "residence time" of water in the reservoir; calculated as ratio between storage capacity (Cap_mcm) and total annual flow (derived from Dis_avg_ls); values capped at 10,000 indicate exceedingly high values, which may be due to inconsistencies in the data and/or incorrect allocation to the river network and the associated discharges.
Field Name: degree_of_regulation_pc
Shapefile Field Name: deg_of_reg
Data Type: double
Downstream Passage Route
Feature Type: Dams
Definition: The type of downstream fish passage route associated with the dam.
Field Name: down_passage_route
Shapefile Field Name: dspass
Data Type: varchar(32)
Downstream Passage Route Code
Feature Type: Dams
Definition: The type of downstream fish passage route associated with the dam.
Field Name: down_passage_route_code
Shapefile Field Name: dspass_c
Data Type: integer
Code Name Description 1 Bypass A fish screen is used to channel juvenile fish downstream of the structure, bypassing the turbine channel. 2 River channel Fish move downstream of the structure via the natural river channel. 3 Spillway Fish move downstream of the structure by passing over the spillway. 4 Turbine Fish move downstream of the structure by passing through the turbine channel.
Expected End of Life
Feature Type: Dams
Definition: The year the structure will reach its expected end of life.
Field Name: expected_end_of_life
Shapefile Field Name: expect_eol
Data Type: integer
Facility Name (English)
Feature Type: Dams
Definition: Given or known name of a larger facility that a dam structure is associated with, English.
Field Name: facility_name_en
Shapefile Field Name: facname_en
Data Type: varchar(512)
Facility Name (French)
Feature Type: Dams
Definition: Given or known name of a larger facility that a dam structure is associated with, French.
Field Name: facility_name_fr
Shapefile Field Name: facname_fr
Data Type: varchar(512)
Feature Data Source Details
Feature Type: Dams
Definition: Link that identifies the data source for the feature's attributes.
Field Name: datasource_url
Shapefile Field Name: data_src
Data Type: url
Feature Type
Feature Type: Dams
Definition: The type of feature the data point represents.
Field Name: feature_type
Shapefile Field Name: feat_type
Data Type: text
Federal Compliance Status
Feature Type: Dams
Definition: The status of regulatory compliance with the federal licensing body.
Field Name: federal_compliance_status
Shapefile Field Name: cplstat_fd
Data Type: varchar(64)
Federal Flow Requirements (m3/s)
Feature Type: Dams
Definition: Minimum flow recommendations for the dam structure in cubic meters per second. Based on assessments by Fisheries and Oceans Canada for the protection of fish and fish habitat.
Field Name: federal_flow_req
Shapefile Field Name: fd_flo_m3s
Data Type: double
Generating Capacity (MWh)
Feature Type: Dams
Definition: The amount of electricity the hydroelectric facility can produce in megawatt hours.
Field Name: generating_capacity_mwh
Shapefile Field Name: gen_c_mwh
Data Type: double
Has Hydro Peaking System
Feature Type: Dams
Definition: Indicates if the dam employs a hydro peaking system.
Field Name: hydro_peaking_system
Shapefile Field Name: hydro_peak
Data Type: boolean
Height (m)
Feature Type: Dams
Definition: Reported height of the dam in meters. Depending on the data source this could variably be height of dam wall, crest height, or head height.
Field Name: height_m
Shapefile Field Name: height_m
Data Type: double
Include in ACT
Feature Type: Dams
Definition: Indicates whether the snapped_ncc field is populated
Field Name: include_in_act
Data Type: boolean
Lake Control
Feature Type: Dams
Definition: Indicates if a reservoir has been built at the location of an existing natural lake using a lake control structure.
Field Name: lake_control
Shapefile Field Name: lakectrl
Data Type: varchar(32)
Lake Control Code
Feature Type: Dams
Definition: Indicates if a reservoir has been built at the location of an existing natural lake using a lake control structure.
Field Name: lake_control_code
Shapefile Field Name: lakectrl_c
Data Type: integer
Code Name Description 1 Yes lake control structure raises original lake level 2 Enlarged lake control structure enlarged the original lake surface area 3 Maybe not sure, but data seems to indicate a lake control structure
Last Maintenance Date
Feature Type: Dams
Definition: Date of last maintenance or renovation work performed on the barrier.
Field Name: maintenance_last
Shapefile Field Name: last_maint
Data Type: date
Last Modified
Feature Type: Dams
Definition: The autogenerated date from the attribute data source updates table corresponding to the date that information in a specific row was last updated in the CABD
Field Name: last_modified
Shapefile Field Name: last_mod
Data Type: date
Latitude
Feature Type: Dams
Definition: Latitude of point location of dam in decimal degrees; the point location is only an approximation of the actual dam location.
Field Name: latitude
Shapefile Field Name: lat_dd
Data Type: double
Length (m)
Feature Type: Dams
Definition: Length of the crest of the dam from one bank (or abutment) to the other in meters.
Field Name: length_m
Shapefile Field Name: length_m
Data Type: double
Location
Feature Type: Dams
Field Name: geometry
Data Type: geometry
Longitude
Feature Type: Dams
Definition: Longitude of point location of dam in decimal degrees; the point location is only an approximation of the actual dam location.
Field Name: longitude
Shapefile Field Name: long_dd
Data Type: double
Municipality
Feature Type: Dams
Definition: The municipality the dam is located in.
Field Name: municipality
Shapefile Field Name: muni_name
Data Type: varchar(512)
NHN Watershed ID
Feature Type: Dams
Definition: A code referencing the work unit ‘Dataset Name’ from the National Hydrographic Network (NHN) that the feature is located in.
Field Name: nhn_watershed_id
Shapefile Field Name: nhnws_id
Data Type: varchar(7)
NHN Watershed Name
Feature Type: Dams
Definition: The name of the NHN sub-sub drainage area.
Field Name: nhn_watershed_name
Shapefile Field Name: nhnws_name
Data Type: varchar(500)
Next Maintenance Date
Feature Type: Dams
Definition: Date of the next scheduled maintenance or renovation work performed on the barrier.
Field Name: maintenance_next
Shapefile Field Name: next_maint
Data Type: date
Number of Turbines
Feature Type: Dams
Definition: The number of turbines in the dam structure.
Field Name: turbine_number
Shapefile Field Name: turbnum
Data Type: integer
Operating Note
Feature Type: Dams
Definition: Unstructured comments on important operation considerations for the dam structure.
Field Name: operating_notes
Shapefile Field Name: opernote
Data Type: text
Operating Status
Feature Type: Dams
Definition: The operating status of the dam.
Field Name: operating_status
Shapefile Field Name: operstat
Data Type: varchar(32)
Operating Status Code
Feature Type: Dams
Definition: The operating status of the dam.
Field Name: operating_status_code
Shapefile Field Name: operstat_c
Data Type: integer
Code Name Description 1 Abandoned/ Orphaned Structure is not in operation; has no identifiable owner with legal liability. 2 Active Structure is in operation; functioning as intended. 3 Decommissioned/ Removed Structure dismantled/removed. 4 Retired/ Closed Structure was withdrawn from service but remains. 5 Remediated Structure remains in place but has been modified to allow fish to pass. 99 Unknown Operating status of the structure is not known.
Owner
Feature Type: Dams
Definition: Person, company, organization, government unit, public utility, corporation or other entity which either holds a water license to operate a dam or retains the legal property title on the dam site.
Field Name: owner
Shapefile Field Name: owner
Data Type: varchar(512)
Ownership Type
Feature Type: Dams
Definition: The ownership category associated with the dam.
Field Name: ownership_type
Shapefile Field Name: owntype
Data Type: varchar(32)
Ownership Type Code
Feature Type: Dams
Definition: The ownership category associated with the dam.
Field Name: ownership_type_code
Shapefile Field Name: owntype_c
Data Type: integer
Code Name Description 1 Charity/ Non-profit Privately held entities that do not provide financial benefits to their members or organizations; independent from any government. 2 Federal National government organization (i.e., department, agency, crown corporation) that performs national level regulatory and administrative functions. 3 Municipal Local governing body that provides services, facilities, safety, and infrastructure for communities. 4 Private Organization, corporation, or partnership operated for profit that is not public or controlled by one or more public corporations. 5 Provincial/ Territorial Regional government organization with jurisdiction over their specific regional boundaries. 6 Other Ownership is known, but different than those defined in this table. This category includes private citizens. 7 Indigenous Indigenous peoples, groups, or communities. 99 Unknown Ownership is unknown.
Passability Status
Feature Type: Dams
Definition: The degree to which the structure acts as a barrier to fish in the upstream direction.
Field Name: passability_status
Shapefile Field Name: pass_stat
Data Type: varchar(32)
Passability Status Code
Feature Type: Dams
Definition: Code referencing the degree to which the structure acts as a barrier to fish in the upstream direction.
Field Name: passability_status_code
Shapefile Field Name: passstat_c
Data Type: integer
Code Name Description 1 Barrier The structure acts as a hard barrier to all aquatic species. If the only upstream passage measure indicated for a structure is trap and truck, the structure is marked as a Barrier until other information indicates it should be a Partial Barrier. 2 Partial Barrier The structure may act as a barrier to some aquatic species but may also be passable to others. Structures that include a fishway are marked as a Partial Barrier as the fishway is assumed to improve passage at the site. 3 Passable The structure does not act as a barrier to aquatic species. Structures that are decommissioned or removed are marked as Passable, assuming decommissioned or removed structures no longer impact fish passage. 4 Unknown The passability status of the structure is unknown. 5 NA - No Structure Not applicable - there is no structure at this location. 6 NA - Decommissioned/ Removed Not applicable - the structure has been decommissioned or removed.
Passability Status Note
Feature Type: Dams
Definition: Unstructured notes to provide context for the assigned passability status code (e.g., species restrictions)
Field Name: passability_status_note
Shapefile Field Name: passnote
Data Type: text
Province/Territory Code
Feature Type: Dams
Definition: The province or territory the dam is located in.
Field Name: province_territory_code
Shapefile Field Name: pr_terr_c
Data Type: varchar(2)
Code Name Description ab Alberta bc British Columbia mb Manitoba nb New Brunswick nl Newfoundland and Labrador ns Nova Scotia nt Northwest Territories nu Nunavut on Ontario pe Prince Edward Island qc Quebec sk Saskatchewan us United States yt Yukon
Province/Territory Name
Feature Type: Dams
Definition: The province or territory the dam is located in.
Field Name: province_territory
Shapefile Field Name: pr_terr
Data Type: varchar(32)
Provincial Compliance Status
Feature Type: Dams
Definition: The status of regulatory compliance with provincial licensing body.
Field Name: provincial_compliance_status
Shapefile Field Name: cplstat_pr
Data Type: varchar(64)
Provincial Flow Requirements (m3/s)
Feature Type: Dams
Definition: Legislated flow requirements for the dam structure in cubic meters per second regulated by the provincial licensing body.
Field Name: provincial_flow_req
Shapefile Field Name: pr_flo_m3s
Data Type: double
Reservoir Area (km2)
Feature Type: Dams
Definition: Representative surface area of reservoir in square kilometers.
Field Name: reservoir_area_skm
Shapefile Field Name: resareakm2
Data Type: double
Reservoir Depth (m)
Feature Type: Dams
Definition: Average depth of reservoir in meters.
Field Name: reservoir_depth_m
Shapefile Field Name: res_dpth_m
Data Type: double
Reservoir Name (English)
Feature Type: Dams
Definition: Name of the reservoir or controlled lake (i.e., impounded waterbody), English.
Field Name: reservoir_name_en
Shapefile Field Name: resname_en
Data Type: varchar(512)
Reservoir Name (French)
Feature Type: Dams
Definition: Name of the reservoir or controlled lake (i.e., impounded waterbody), French.
Field Name: reservoir_name_fr
Shapefile Field Name: resname_fr
Data Type: varchar(512)
Reservoir Present
Feature Type: Dams
Definition: Indicates if a reservoir is present due to the creation of the dam.
Field Name: reservoir_present
Shapefile Field Name: res_presnt
Data Type: boolean
Spillway Capacity
Feature Type: Dams
Definition: The designed capacity of the spillway in m3 per second.
Field Name: spillway_capacity
Shapefile Field Name: spil_c_m3s
Data Type: double
Spillway Type
Feature Type: Dams
Definition: The type of spillway associated with the dam structure.
Field Name: spillway_type
Shapefile Field Name: spilltype
Data Type: varchar(32)
Spillway Type Code
Feature Type: Dams
Definition: The type of spillway associated with the dam structure.
Field Name: spillway_type_code
Shapefile Field Name: spilltyp_c
Data Type: integer
Code Name Description 1 Combined Single spillway that acts as both the principal and emergency spillway. 2 Free Surplus water falls freely from the crest of the weir; a straight drop spillway or free overfall spillway. 3 Gated Surplus water is regulated with a gate to prevent downstream flooding. 4 Other The spillway type of the dam structure is defined as something other than ‘combined’, ‘free’, or ‘gated’. 5 None Structure does not have a spillway. 99 Unknown Structure has a spillway, but the type of spillway is unknown.
Storage Capacity (mcm)
Feature Type: Dams
Definition: Storage capacity of reservoir in million cubic meters.
Field Name: storage_capacity_mcm
Shapefile Field Name: strg_c_mcm
Data Type: double
Structure Type
Feature Type: Dams
Definition: The type of structure.
Field Name: structure_type
Shapefile Field Name: struc_type
Data Type: varchar(32)
Structure Type Code
Feature Type: Dams
Definition: The type of structure.
Field Name: structure_type_code
Shapefile Field Name: struc_c
Data Type: integer
Code Name Description 1 Dam - Arch A structure, typically made of concrete, that is curved to form a horizontal arch with its convex side in the upstream direction. 2 Dam - Buttress A buttress dam, sometimes referred to as a hallow dam, is a structure made of concrete or masonry that consists of inclined panels or a series of arches supported by buttresses on its downstream side. 3 Dam - Embankment A structure constructed by building up and compacting several layers of excavated earth and/or rock. This category includes causeways. 4 Dam - Gravity A structure, typically made of concrete and/or masonry, that relies on the weight of its materials to withstand external forces. 5 Dam - Multiple Arch A buttress dam composed of a series of multiple arches. 6 Dam - Other The type of dam is known, but is different than those defined in this table (e.g., arch-gravity, sheet pile, timber crib, etc.). 7 Weir A type of low-head dam that allows the flow of water over the top of or underneath the structure. A weir may be used to raise the water level upstream, regulate flow, or divert flow from the system. 8 Spillway A structure that allows for the emergency or controlled release of surplus water downstream of a dam or other barrier structure. 9 Powerhouse A hydro power facility structure that houses generators and turbines used for generating hydropower. 10 Lateral Barrier A structure that is used to regulate or hold back water. Some lateral barrier structures, such as dikes and embankments, run parallel to a body of water and are used to hold back flood waters. Other lateral barriers, like canals, are used to convey water for a specific purpose such as irrigation or navigation. 11 Lock A structure, consisting of gates, used on navigable waterways to regulate (raise/lower) the water depth on a stretch of river or stream so vessels may pass. 12 Aboiteau/ Tide Gate A gate structure used in coastal areas (e.g., marshland), commonly built into an earthen dike or embankment, that permits floodwater to drain during low tide but prevents the overflow of water during high tide. 13 Other The type of structure is known, but is different than those defined in this table (e.g., intake structure, lake control structure, etc.). 99 Unknown The type of structure is unknown.
Turbine Type
Feature Type: Dams
Definition: The type of turbine in the dam structure.
Field Name: turbine_type
Shapefile Field Name: turbtype
Data Type: varchar(32)
Turbine Type Code
Feature Type: Dams
Definition: The type of turbine in the dam structure.
Field Name: turbine_type_code
Shapefile Field Name: turbtype_c
Data Type: integer
Code Name Description 1 Cross-flow An impulse turbine used in smaller hydroelectric sites with power outputs between 5 and 100 kW. Known also as Banki-Mitchell or Ossberger turbines. 2 Francis A reaction (propeller) turbine commonly used in medium- or large-scale hydroelectric plants for head heights as low as 2 m and as high as 300 m. 3 Kaplan A reaction (propeller) turbine with axial-flow and adjustable blades. Most useful for use in dams with large volumes of flow. 4 Pelton An impulse turbine commonly used in facilities with head height greater than 300 m. 5 Other Turbine type is known, but different than those defined in this table. 99 Unknown Turbine type is unknown.
Updates Pending
Feature Type: Dams
Definition: There are updates pending for this feature.
Field Name: updates_pending
Shapefile Field Name: upd_pend
Data Type: boolean
Upstream Catchment Area (km2)
Feature Type: Dams
Definition: Area of upstream catchment draining into the reservoir in square kilometers. The area of upstream catchment is defined by "Elementary Catchment" units in the National Hydrography Network.
Field Name: catchment_area_skm
Shapefile Field Name: up_ca_km2
Data Type: double
Upstream Linear Length (km)
Feature Type: Dams
Definition: The amount of unobstructed linear kilometers upstream of the barrier that would become avaliable to aquatic species if the barrier were to be removed.
Field Name: upstream_linear_km
Shapefile Field Name: up_len_km
Data Type: double
Upstream Passage Type
Feature Type: Dams
Definition: The type of upstream fish passage measure associated with the dam.
Field Name: up_passage_type
Shapefile Field Name: uppasstype
Data Type: varchar(32)
Upstream Passage Type Code
Feature Type: Dams
Definition: The type of upstream fish passage measure associated with the dam.
Field Name: up_passage_type_code
Shapefile Field Name: uppass_c
Data Type: integer
Code Name Description 1 Denil A series of close-spaced baffles placed on the bottom and/or sides of an inclined (up to 20%) channel, to redirect the flow of water and reduce its velocity, allowing fish to ascend and migrate upstream. 2 Nature-like fishway A diversion channel excavated along the bank of the river, allowing fish to bypass the barrier structure. 3 Pool and weir A series of small overflow pools and weirs forming steps that fish can jump between, migrating upstream. 4 Pool and weir with hole A series of small overflow pools and weirs provided with submerged holes in which fish can jump between, migrating upstream. 5 Trap and truck Fish are trapped and transported upstream of the barrier where they are released. 6 Vertical slot A variation of pool and weir fishways where weirs are replaced by walls with vertical slots in which fish can pass through, allowing fish to swim at their desired depth. 7 Other 8 No structure No fish passage structure is present. 9 Eel ladder A fish passage structure specifically designed to pass eel (e.g., climbing ramp, mussel rope). 99 Unknown
Use Fisheries
Feature Type: Dams
Definition: Indicates the dam is used for fisheries purposes, and the extent to which fisheries are a planned use.
Field Name: use_fish
Shapefile Field Name: usefish
Data Type: varchar(32)
Use Fisheries Code
Feature Type: Dams
Definition: Indicates the dam is used for fisheries purposes, and the extent to which fisheries are a planned use.
Field Name: use_fish_code
Shapefile Field Name: usefish_c
Data Type: integer
Code Name Description 1 Main The primary/most important purpose of the dam. 2 Major A primary/important use of the dam but not the main use. 3 Secondary The secondary use of the dam.
Use Flood Control
Feature Type: Dams
Definition: Indicates the dam is used for flood control purposes, and the extent to which flood control is a planned use.
Field Name: use_floodcontrol
Shapefile Field Name: useflood
Data Type: varchar(32)
Use Flood Control Code
Feature Type: Dams
Definition: Indicates the dam is used for flood control purposes, and the extent to which flood control is a planned use.
Field Name: use_floodcontrol_code
Shapefile Field Name: useflood_c
Data Type: integer
Code Name Description 1 Main The primary/most important purpose of the dam. 2 Major A primary/important use of the dam but not the main use. 3 Secondary The secondary use of the dam.
Use Hydroelectricity
Feature Type: Dams
Definition: Indicates the dam is used for hydroelectric energy production, and the extent to which hydroelectric production is a planned use.
Field Name: use_electricity
Shapefile Field Name: usehydro
Data Type: varchar(32)
Use Hydroelectricity Code
Feature Type: Dams
Definition: Indicates the dam is used for hydroelectric energy production, and the extent to which hydroelectric production is a planned use.
Field Name: use_electricity_code
Shapefile Field Name: usehydro_c
Data Type: integer
Code Name Description 1 Main The primary/most important purpose of the dam. 2 Major A primary/important use of the dam but not the main use. 3 Secondary The secondary use of the dam.
Use Invasive Species Control
Feature Type: Dams
Definition: Indicates the dam is used to control invasive species and the extent to which invasive species control is a planned use.
Field Name: use_invasivespecies
Shapefile Field Name: useais
Data Type: varchar(32)
Use Invasive Species Control Code
Feature Type: Dams
Definition: Indicates the dam is used to control invasive species and the extent to which invasive species control is a planned use.
Field Name: use_invasivespecies_code
Shapefile Field Name: useais_c
Data Type: integer
Code Name Description 1 Main The primary/most important purpose of the dam. 2 Major A primary/important use of the dam but not the main use. 3 Secondary The secondary use of the dam.
Use Irrigation
Feature Type: Dams
Definition: Indicates the dam is used for irrigation purposes, and the extent to which irrigation is a planned use.
Field Name: use_irrigation
Shapefile Field Name: useirrig
Data Type: varchar(32)
Use Irrigation Code
Feature Type: Dams
Definition: Indicates the dam is used for irrigation purposes, and the extent to which irrigation is a planned use.
Field Name: use_irrigation_code
Shapefile Field Name: useirrig_c
Data Type: integer
Code Name Description 1 Main The primary/most important purpose of the dam. 2 Major A primary/important use of the dam but not the main use. 3 Secondary The secondary use of the dam.
Use Other
Feature Type: Dams
Definition: Indicates the dam is used for "other" purposes, and the extent to which it is a planned use.
Field Name: use_other
Shapefile Field Name: useother
Data Type: varchar(32)
Use Other Code
Feature Type: Dams
Definition: Indicates the dam is used for "other" purposes, and the extent to which it is a planned use.
Field Name: use_other_code
Shapefile Field Name: useother_c
Data Type: integer
Code Name Description 1 Main The primary/most important purpose of the dam. 2 Major A primary/important use of the dam but not the main use. 3 Secondary The secondary use of the dam.
Use Pollution Control
Feature Type: Dams
Definition: Indicates the dam is used for pollution control purposes, and the extent to which pollution control is a planned use.
Field Name: use_pollution
Shapefile Field Name: usepoll
Data Type: varchar(32)
Use Pollution Control Code
Feature Type: Dams
Definition: Indicates the dam is used for pollution control purposes, and the extent to which pollution control is a planned use.
Field Name: use_pollution_code
Shapefile Field Name: usepoll_c
Data Type: integer
Code Name Description 1 Main The primary/most important purpose of the dam. 2 Major A primary/important use of the dam but not the main use. 3 Secondary The secondary use of the dam.
Use Recreation
Feature Type: Dams
Definition: Indicates the dam is used for recreation purposes, and the extent to which recreation is a planned use.
Field Name: use_recreation
Shapefile Field Name: userec
Data Type: varchar(32)
Use Recreation Code
Feature Type: Dams
Definition: Indicates the dam is used for recreation purposes, and the extent to which recreation is a planned use.
Field Name: use_recreation_code
Shapefile Field Name: userec_c
Data Type: integer
Code Name Description 1 Main The primary/most important purpose of the dam. 2 Major A primary/important use of the dam but not the main use. 3 Secondary The secondary use of the dam.
Use Water Supply
Feature Type: Dams
Definition: Indicates the dam is used for water supply purposes, and the extent to which water supply is a planned use.
Field Name: use_supply
Shapefile Field Name: usesupp
Data Type: varchar(32)
Use Water Supply Code
Feature Type: Dams
Definition: Indicates the dam is used for water supply purposes, and the extent to which water supply is a planned use.
Field Name: use_supply_code
Shapefile Field Name: usesupp_c
Data Type: integer
Code Name Description 1 Main The primary/most important purpose of the dam. 2 Major A primary/important use of the dam but not the main use. 3 Secondary The secondary use of the dam.
Use Wildlife Conservation
Feature Type: Dams
Definition: Indicates the structure is used for wildlife conservation purposes, and the extent to which wildlife conservation is a planned use.
Field Name: use_conservation
Shapefile Field Name: usewcon
Data Type: varchar(32)
Use Wildlife Conservation Code
Feature Type: Dams
Definition: Indicates the structure is used for wildlife conservation purposes, and the extent to which wildlife conservation is a planned use.
Field Name: use_conservation_code
Shapefile Field Name: usewcon_c
Data Type: integer
Code Name Description 1 Main The primary/most important purpose of the dam. 2 Major A primary/important use of the dam but not the main use. 3 Secondary The secondary use of the dam.
Use for Network Analysis
Feature Type: Dams
Definition: If true, the data point representing this feature is/should be snapped to hydrographic networks for analysis purposes. Examples of structures that should not be snapped to hydrographic networks include powerhouses, some agricultural pond dams, canal walls, and other lateral barriers.
Field Name: use_analysis
Shapefile Field Name: useanalysi
Data Type: boolean
Waterbody Name (English)
Feature Type: Dams
Definition: Name of waterbody in which the dam is recorded, English.
Field Name: waterbody_name_en
Shapefile Field Name: wbname_en
Data Type: varchar(512)
Waterbody Name (French)
Feature Type: Dams
Definition: Name of waterbody in which the dam is recorded, French.
Field Name: waterbody_name_fr
Shapefile Field Name: wbname_fr
Data Type: varchar(512)
Year Removed
Feature Type: Dams
Definition: The year the dam was decommissioned, removed, replaced, subsumed, or destroyed.
Field Name: removed_year
Shapefile Field Name: remove_yr
Data Type: integer
Fishways Attributes
Architect
Feature Type: Fishways
Definition: Company/organization that designed the fishway structure.
Field Name: architect
Shapefile Field Name: architect
Data Type: text
Attraction Estimate (%)
Feature Type: Fishways
Definition: Portion of individuals attracted to the fishway in percent.
Field Name: estimate_of_attraction_pct
Shapefile Field Name: eoa_pct
Data Type: double
Average Velocity of Water Flow (m/s)
Feature Type: Fishways
Definition: Average velocity of water flow through the fishway in m/s.
Field Name: mean_fishway_velocity_ms
Shapefile Field Name: avg_vel_ms
Data Type: double
Completeness Level
Feature Type: Fishways
Definition: The level of information available for the fishway in the CABD.
Field Name: complete_level
Shapefile Field Name: comp_lvl
Data Type: varchar(32)
Completeness Level Code
Feature Type: Fishways
Field Name: complete_level_code
Shapefile Field Name: complvl_c
Data Type: integer
Code Name Description 1 Unverified Record is not verified. 2 Minimal Only location is verified. 3 Moderate Location and some attributes are known. 4 Complete Location and all attributes are known.
Constructed By
Feature Type: Fishways
Definition: Name of the company that constructed the fishway.
Field Name: constructed_by
Shapefile Field Name: const_by
Data Type: text
Contracted By
Feature Type: Fishways
Definition: Name of the agency that contracted the fishway.
Field Name: contracted_by
Shapefile Field Name: contrac_by
Data Type: text
Dam Identifier
Feature Type: Fishways
Definition: The unique barrier identifier corresponding to the dam that the fishway structure is associated with.
Field Name: dam_id
Shapefile Field Name: dam_id
Data Type: uuid
Designed Based on Biology
Feature Type: Fishways
Definition: Indicates whether the fishway was designed based on the biology of the species.
Field Name: designed_on_biology
Shapefile Field Name: bio_design
Data Type: boolean
Elevation (m)
Feature Type: Fishways
Definition: Change in height between fishway exit and entrance in meters.
Field Name: elevation_m
Shapefile Field Name: elev_m
Data Type: double
Engineering Notes
Feature Type: Fishways
Definition: Notes regarding design and construction of the fishway.
Field Name: engineering_notes
Shapefile Field Name: eng_note
Data Type: text
Entrance Location
Feature Type: Fishways
Definition: Indicates if the entrance of the fishway is located mid-stream or on the bank.
Field Name: entrance_location
Shapefile Field Name: entr_loc
Data Type: varchar(32)
Entrance Location Code
Feature Type: Fishways
Field Name: entrance_location_code
Shapefile Field Name: entr_loc_c
Data Type: integer
Code Name Description 1 Midstream 2 Bank
Entrance Position
Feature Type: Fishways
Definition: Indicates the entrance position of the fishway in the water column.
Field Name: entrance_position
Shapefile Field Name: entr_pos
Data Type: varchar(32)
Entrance Position Code
Feature Type: Fishways
Field Name: entrance_position_code
Shapefile Field Name: entr_pos_c
Data Type: integer
Code Name Description 1 Bottom 2 Surface 3 Bottom and Surface 4 Mid-column
Feature Data Source Details
Feature Type: Fishways
Definition: Link that identifies the data source for the feature's attributes.
Field Name: datasource_url
Shapefile Field Name: data_src
Data Type: url
Feature Type
Feature Type: Fishways
Definition: The type of feature the data point represents.
Field Name: feature_type
Shapefile Field Name: feat_typ
Data Type: text
Fishway Type
Feature Type: Fishways
Definition: The type of fishway structure (values are consistent with 'Upstream Passage Type' values for dams).
Field Name: fishpass_type
Shapefile Field Name: fw_type
Data Type: varchar(32)
Fishway Type Code
Feature Type: Fishways
Field Name: fishpass_type_code
Shapefile Field Name: fw_type_c
Data Type: integer
Code Name Description 1 Denil A series of close-spaced baffles placed on the bottom and/or sides of an inclined (up to 20%) channel, to redirect the flow of water and reduce its velocity, allowing fish to ascend and migrate upstream. 2 Nature-like fishway A diversion channel excavated along the bank of the river, allowing fish to bypass the barrier structure. 3 Pool and weir A series of small overflow pools and weirs forming steps that fish can jump between, migrating upstream. 4 Pool and weir with hole A series of small overflow pools and weirs provided with submerged holes in which fish can jump between, migrating upstream. 5 Trap and truck Fish are trapped and transported upstream of the barrier where they are released. 6 Vertical slot A variation of pool and weir fishways where weirs are replaced by walls with vertical slots in which fish can pass through, allowing fish to swim at their desired depth. 7 Other 8 No structure No fish passage structure is present. 9 Eel ladder A fish passage structure specifically designed to pass eel (e.g., climbing ramp, mussel rope). 99 Unknown
Gradient
Feature Type: Fishways
Definition: The fishway's angle of inclination in percent.
Field Name: gradient
Shapefile Field Name: gradient
Data Type: double
Has Evaluating Studies
Feature Type: Fishways
Definition: Indicates whether an evaluation study has been performed at the fishway.
Field Name: has_evaluating_studies
Shapefile Field Name: eval_study
Data Type: boolean
Is Modified
Feature Type: Fishways
Definition: Indicates if the fishway has had any post-construction modifications.
Field Name: modified
Shapefile Field Name: modified
Data Type: boolean
Latitude
Feature Type: Fishways
Definition: The geographic x-coordinate representing the location of the fishway.
Field Name: latitude
Shapefile Field Name: lat_dd
Data Type: double
Length (m)
Feature Type: Fishways
Definition: The length of the fishway in meters.
Field Name: length_m
Shapefile Field Name: length_m
Data Type: double
Location
Feature Type: Fishways
Field Name: geometry
Data Type: geometry
Longitude
Feature Type: Fishways
Definition: The geographic y-coordinate representing the location of the fishway.
Field Name: longitude
Shapefile Field Name: long_dd
Data Type: double
Maximum Velocity of Water Flow (m/s)
Feature Type: Fishways
Definition: Maximum velocity of water flow recorded in the fishway in m/s.
Field Name: max_fishway_velocity_ms
Shapefile Field Name: max_vel_ms
Data Type: double
Mean channel depth (m)
Feature Type: Fishways
Definition: Depth of fishway channel, in meters, during operation.
Field Name: depth_m
Shapefile Field Name: depth_m
Data Type: double
Modification Purpose
Feature Type: Fishways
Definition: Purpose of post-construction modifications.
Field Name: modification_purpose
Shapefile Field Name: mod_purp
Data Type: text
Modification Year
Feature Type: Fishways
Definition: The year that post-construction modifications were completed.
Field Name: modification_year
Shapefile Field Name: mod_yr
Data Type: integer
Monitoring Equipment
Feature Type: Fishways
Definition: Monitoring equipment used at the fishway.
Field Name: monitoring_equipment
Shapefile Field Name: mon_equip
Data Type: text
Municipality
Feature Type: Fishways
Definition: The municipality the fishway is located in.
Field Name: municipality
Shapefile Field Name: muni_name
Data Type: varchar(512)
NHN Watershed ID
Feature Type: Fishways
Definition: A code referencing the work unit ‘Dataset Name’ from the National Hydrographic Network (NHN) that the feature is located in.
Field Name: nhn_watershed_id
Shapefile Field Name: nhnws_id
Data Type: varchar(7)
NHN Watershed Name
Feature Type: Fishways
Definition: The name of the NHN sub-sub drainage area.
Field Name: nhn_watershed_name
Shapefile Field Name: nhnws_name
Data Type: varchar(500)
Nature of Evaluation Studies
Feature Type: Fishways
Definition: The type of evaluation study performed.
Field Name: nature_of_evaluation_studies
Shapefile Field Name: natofeval
Data Type: text
Operated By
Feature Type: Fishways
Definition: Agency responsible for operating the fishway.
Field Name: operated_by
Shapefile Field Name: oper_by
Data Type: text
Operation Notes
Feature Type: Fishways
Definition: Unstructured comments on important operation considerations for the fishway.
Field Name: operating_notes
Shapefile Field Name: oper_note
Data Type: text
Operation Period
Feature Type: Fishways
Definition: The dates the fishway is in operation.
Field Name: operation_period
Shapefile Field Name: oper_per
Data Type: text
Plans Held By
Feature Type: Fishways
Definition: Name of the agency that possesses the plans for the fishway.
Field Name: plans_held_by
Shapefile Field Name: plans_held
Data Type: text
Province/Territory Code
Feature Type: Fishways
Field Name: province_territory_code
Shapefile Field Name: pr_terr_c
Data Type: varchar(2)
Code Name Description ab Alberta bc British Columbia mb Manitoba nb New Brunswick nl Newfoundland and Labrador ns Nova Scotia nt Northwest Territories nu Nunavut on Ontario pe Prince Edward Island qc Quebec sk Saskatchewan us United States yt Yukon
Province/Territory Name
Feature Type: Fishways
Definition: The province or territory the fishway is located in.
Field Name: province_territory
Shapefile Field Name: pr_terr
Data Type: varchar(32)
Purpose of Fishway
Feature Type: Fishways
Definition: The reason the fishway was designed and implemented.
Field Name: purpose
Shapefile Field Name: purpose
Data Type: text
Reference Identifier
Feature Type: Fishways
Definition: The reference for the literature (peer-reviewed and "grey") used to gather additional information about the fishway.
Field Name: fishway_reference_id
Shapefile Field Name: fw_ref_id
Data Type: varchar(256)
River/Stream Name (English)
Feature Type: Fishways
Definition: Name of river/stream in which the fishway is recorded (English).
Field Name: river_name_en
Shapefile Field Name: rivname_en
Data Type: varchar(512)
River/Stream Name (French)
Feature Type: Fishways
Definition: Name of river/stream in which the fishway is recorded (French).
Field Name: river_name_fr
Shapefile Field Name: rivname_fr
Data Type: varchar(512)
Species Known To Not Use
Feature Type: Fishways
Definition: Species where it is known that the fishway presents a significant barrier to migration.
Field Name: known_notuse
Shapefile Field Name: spp_use_n
Data Type: array(varchar)
Species Known To Use
Feature Type: Fishways
Definition: Species that are known to use the fishway.
Field Name: known_use
Shapefile Field Name: spp_use_y
Data Type: array(varchar)
Structure Name (English)
Feature Type: Fishways
Definition: The given or known name of the fishway structure or the dam with which it is associated (English).
Field Name: structure_name_en
Shapefile Field Name: strcnameen
Data Type: varchar(512)
Structure Name (French)
Feature Type: Fishways
Definition: The given or known name of the fishway structure or the dam with which it is associated (French).
Field Name: structure_name_fr
Shapefile Field Name: strcnamefr
Data Type: varchar(512)
System Identifier
Feature Type: Fishways
Definition: Unique identifier for each fishway point.
Field Name: cabd_id
Shapefile Field Name: cabd_id
Data Type: uuid
Transit Success Estimate (%)
Feature Type: Fishways
Definition: Estimated percentage of individuals that successfully pass through the fishway.
Field Name: estimate_of_passage_success_pct
Shapefile Field Name: eops_pct
Data Type: double
Updates Pending
Feature Type: Fishways
Definition: There are updates pending for this feature.
Field Name: updates_pending
Shapefile Field Name: upd_pend
Data Type: boolean
Waterbody Name (English)
Feature Type: Fishways
Definition: Name of waterbody in which the fishway is recorded (English).
Field Name: waterbody_name_en
Shapefile Field Name: wbname_en
Data Type: varchar(512)
Waterbody Name (French)
Feature Type: Fishways
Definition: Name of waterbody in which the fishway is recorded (French).
Field Name: waterbody_name_fr
Shapefile Field Name: wbname_fr
Data Type: varchar(512)
Year Constructed
Feature Type: Fishways
Definition: Year in which the fishway structure was built.
Field Name: year_constructed
Shapefile Field Name: const_yr
Data Type: integer
Modelled Crossings Attributes
Addressed Status
Feature Type: Modelled Crossings
Definition: Indicates whether the crossing has been rehabilitated in some way to improve fish passage.
Field Name: addressed_status
Shapefile Field Name: addstat
Data Type: varchar(32)
Addressed Status Code
Feature Type: Modelled Crossings
Definition: Indicates whether the crossing has been rehabilitated in some way to improve fish passage.
Field Name: addressed_status_code
Shapefile Field Name: addstat_c
Data Type: integer
Code Name Description 1 Decommissioned/ Removed The crossing has been decommissioned or removed. 2 Replaced The crossing has been replaced with a fully passable structure. 3 Fish Ladder A fish ladder has been added to the crossing to improve fish passage. 4 Baffling Baffling has been installed at the crossing to reduce water velocity and provide resting areas for fish. 5 Backwatering Backwatering has been added at the crossing to reduce water velocity and turbulence and raise water levels. 6 Other The crossing has been addressed in some way to improve fish passage, but the measure is different than those defined in this table. 99 Unknown It is unknown whether the crossing has been addressed to improve fish passage.
Assessment Type
Feature Type: Modelled Crossings
Definition: The type of assessment carried out at the stream crossing.
Field Name: assessment_type
Shapefile Field Name: atype
Data Type: varchar(32)
Assessment Type Code
Feature Type: Modelled Crossings
Definition: The type of assessment carried out at the stream crossing.
Field Name: assessment_type_code
Shapefile Field Name: atype_c
Data Type: integer
Code Name Description 1 Rapid A rapid assessment has been conducted at the crossing. 2 Full A full assessment has been conducted at the crossing. 3 Other An assessment has been conducted at the crossing, but the type of assessment is different than those defined in this table. 4 Imagery The crossing has been reviewed through available satellite imagery, but has not been visited in the field. 5 Modelled The crossing has not been visited in the field or reviewed in satellite imagery. 6 Inventory The feature is updated from existing inventories that contain data that cannot be considered assessment data
Barrier Identifier
Feature Type: Modelled Crossings
Definition: Unique identifier for the stream crossing
Field Name: cabd_id
Shapefile Field Name: cabd_id
Data Type: uuid
Comments
Feature Type: Modelled Crossings
Definition: Unstructured comments about the stream crossing.
Field Name: comments
Shapefile Field Name: comments
Data Type: varchar
Crossing Addressed
Feature Type: Modelled Crossings
Definition: If true, the stream crossing has been rehabilitated in some way to improve fish passage.
Field Name: crossing_addressed
Shapefile Field Name: cross_add
Data Type: boolean
Crossing Confirmed
Feature Type: Modelled Crossings
Definition: If true, the existence of the stream crossing has been confirmed through a field visit.
Field Name: crossing_confirmed
Shapefile Field Name: cross_conf
Data Type: boolean
Crossing Subtype
Feature Type: Modelled Crossings
Definition: The crossing subtype
Field Name: crossing_subtype
Shapefile Field Name: cr_styp
Data Type: varchar(32)
Crossing Subtype Code
Feature Type: Modelled Crossings
Definition: The crossing subtype
Field Name: crossing_subtype_code
Shapefile Field Name: cr_styp_c
Data Type: integer
Code Name Description 1 Bridge A bridge has a deck supported by abutments (or stream banks). It may have more than one cell or section separated by one or more piers. 2 Culvert A culvert is a tunnel carrying a stream under a road or railway. A culvert may act as a bridge for traffic to pass on it. 3 Multiple Culvert A multiple culvert consists of two or more culverts at a site. Multiple culverts may be installed on wide channels or in areas with high velocities at the outlet. 4 Ford A ford is a shallow, open stream crossing, in which vehicles pass through the water. Fords may be armored to decrease erosion, and may include pipes to allow flow through the ford. 5 No Upstream Channel A site where water crosses a road through a culvert but no road-stream crossing occurs because there is no channel up-gradient of the road. This can occur at the very headwaters of a stream or where a road crosses a wetland that lacks a stream channel. 99 Unknown The crossing subtype is unknown.
Crossing Type
Feature Type: Modelled Crossings
Definition: The crossing type
Field Name: crossing_type
Shapefile Field Name: cr_typ
Data Type: varchar(32)
Crossing Type Code
Feature Type: Modelled Crossings
Definition: The crossing type
Field Name: crossing_type_code
Shapefile Field Name: cr_typ_c
Data Type: integer
Code Name Description 1 Open-Bottom Structure Open-bottom structures may include bridges, bottomless arch structures, and open bottom box culverts. Open-bottom structures generally have less impact on aquatic habitat than closed-bottom structures. 2 Closed-Bottom Structure Closed-bottom structures may include box culverts, pipe arch culverts, and pipe culverts. They may be used on public roads, forest roads, driveways and in areas where difficult terrain limits other watercourse crossing options. 3 Ford-Like Structure Ford-like structures are low-profile crossings typically used for low-traffic or intermittent use roads to facilitate crossing a stream. 4 No Crossing There is no crossing where anticipated, usually because of incorrect road or stream location on maps. 99 Unknown The crossing type is unknown.
Crossing Type Source
Feature Type: Modelled Crossings
Definition: The source of the crossing type
Field Name: crossing_type_source
Shapefile Field Name: cr_typ_s
Data Type: varchar
Feature Type
Feature Type: Modelled Crossings
Definition: The type of feature the data point represents
Field Name: feature_type
Shapefile Field Name: feat_type
Data Type: text
Latitude
Feature Type: Modelled Crossings
Definition: Latitude of point location of stream crossing in decimal degrees; the point location is only an approximation of the actual stream crossing location.
Field Name: latitude
Shapefile Field Name: lat_dd
Data Type: double precision
Location
Feature Type: Modelled Crossings
Field Name: geometry
Shapefile Field Name: geometry
Data Type: geometry
Longitude
Feature Type: Modelled Crossings
Definition: Longitude of point location of stream crossing in decimal degrees; the point location is only an approximation of the actual stream crossing location.
Field Name: longitude
Shapefile Field Name: long_dd
Data Type: double precision
Municipality
Feature Type: Modelled Crossings
Definition: The municipality the stream crossing is located in.
Field Name: municipality
Shapefile Field Name: muni_name
Data Type: varchar(512)
NHN Watershed ID
Feature Type: Modelled Crossings
Definition: A code referencing the work unit 'Dataset Name' from the National Hydrographic Network (NHN) that the feature is located in.
Field Name: nhn_watershed_id
Shapefile Field Name: nhnws_id
Data Type: varchar(7)
NHN Watershed Name
Feature Type: Modelled Crossings
Definition: The name of the NHN sub-sub drainage area.
Field Name: nhn_watershed_name
Shapefile Field Name: nhnws_name
Data Type: varchar(500)
Passability Status
Feature Type: Modelled Crossings
Definition: The degree to which the stream crossing acts as a barrier to fish in the upstream direction.
Field Name: passability_status
Shapefile Field Name: passstat
Data Type: varchar(32)
Passability Status Code
Feature Type: Modelled Crossings
Definition: The degree to which the stream crossing acts as a barrier to fish in the upstream direction.
Field Name: passability_status_code
Shapefile Field Name: passstat_c
Data Type: integer
Code Name Description 1 Barrier The structure acts as a hard barrier to all aquatic species. If the only upstream passage measure indicated for a structure is trap and truck, the structure is marked as a Barrier until other information indicates it should be a Partial Barrier. 2 Partial Barrier The structure may act as a barrier to some aquatic species but may also be passable to others. Structures that include a fishway are marked as a Partial Barrier as the fishway is assumed to improve passage at the site. 3 Passable The structure does not act as a barrier to aquatic species. Structures that are decommissioned or removed are marked as Passable, assuming decommissioned or removed structures no longer impact fish passage. 4 Unknown The passability status of the structure is unknown. 5 NA - No Structure Not applicable - there is no structure at this location. 6 NA - Decommissioned/ Removed Not applicable - the structure has been decommissioned or removed.
Province/Territory Code
Feature Type: Modelled Crossings
Definition: The province or territory the stream crossing is located in.
Field Name: province_territory_code
Shapefile Field Name: pr_terr_c
Data Type: varchar(2)
Code Name Description ab Alberta bc British Columbia mb Manitoba nb New Brunswick nl Newfoundland and Labrador ns Nova Scotia nt Northwest Territories nu Nunavut on Ontario pe Prince Edward Island qc Quebec sk Saskatchewan us United States yt Yukon
Province/Territory Name
Feature Type: Modelled Crossings
Definition: The province or territory the stream crossing is located in.
Field Name: province_territory
Shapefile Field Name: pr_terr
Data Type: varchar(32)
Railway Operator
Feature Type: Modelled Crossings
Definition: Operator of the railway that uses the stream crossing.
Field Name: railway_operator
Shapefile Field Name: rail_oper
Data Type: varchar
Railway Status
Feature Type: Modelled Crossings
Definition: Operating status of the railway that uses the stream crossing.
Field Name: railway_status
Shapefile Field Name: rail_stat
Data Type: varchar
Roadway Type
Feature Type: Modelled Crossings
Definition: Classification of the road, typically describing the type of service the road is intended to provide.
Field Name: roadway_type
Shapefile Field Name: road_type
Data Type: varchar
Stream Name
Feature Type: Modelled Crossings
Definition: Name of river/stream in which the stream crossing is recorded.
Field Name: stream_name_1
Shapefile Field Name: streamname
Data Type: varchar(512)
Stream Order
Feature Type: Modelled Crossings
Definition: Strahler stream order of the stream in which the stream crossing is recorded.
Field Name: stream_order
Shapefile Field Name: stream_ord
Data Type: integer
Transport Feature Name
Feature Type: Modelled Crossings
Definition: Name of the road or other transportation infrastructure that uses the stream crossing.
Field Name: transport_feature_name
Shapefile Field Name: tr_f_name
Data Type: varchar
Transport Feature Owner
Feature Type: Modelled Crossings
Definition: Owner of the transportation infrastructure that uses the stream crossing.
Field Name: transport_feature_owner
Shapefile Field Name: tr_f_owner
Data Type: varchar
Transport Feature Type
Feature Type: Modelled Crossings
Definition: Type of road or other transportation infrastructure that uses the stream crossing.
Field Name: transport_feature_type
Shapefile Field Name: tr_f_type
Data Type: varchar
Use for Network Analysis
Feature Type: Modelled Crossings
Definition: If true, the data point representing this feature is/should be snapped to hydrographic networks for analysis purposes.
Field Name: use_analysis
Shapefile Field Name: useanalysi
Data Type: boolean
Stream crossings Attributes
Addressed Status
Feature Type: Stream crossings
Definition: Indicates whether the crossing has been rehabilitated in some way to improve fish passage.
Field Name: addressed_status
Data Type: varchar(64)
Addressed Status Code
Feature Type: Stream crossings
Definition: Indicates whether the crossing has been rehabilitated in some way to improve fish passage.
Field Name: addressed_status_code
Data Type: integer
Code Name Description 1 Decommissioned/ Removed The crossing has been decommissioned or removed. 2 Replaced The crossing has been replaced with a fully passable structure. 3 Fish Ladder A fish ladder has been added to the crossing to improve fish passage. 4 Baffling Baffling has been installed at the crossing to reduce water velocity and provide resting areas for fish. 5 Backwatering Backwatering has been added at the crossing to reduce water velocity and turbulence and raise water levels. 6 Other The crossing has been addressed in some way to improve fish passage, but the measure is different than those defined in this table. 99 Unknown It is unknown whether the crossing has been addressed to improve fish passage.
Alignment
Feature Type: Stream crossings
Definition: Alignment of the stream crossing structure(s) relative to the stream at the inlet
Field Name: alignment
Data Type: character varying
Alignment Code
Feature Type: Stream crossings
Definition: Code referencing the alignment of the stream crossing structure(s) relative to the stream at the inlet
Field Name: alignment_code
Data Type: integer
Code Name Description 1 flow-aligned 2 skewed
Assessment Source
Feature Type: Stream crossings
Definition: The source of assessment data, where available
Field Name: assessment_source
Data Type: character varying
Assessment Type
Feature Type: Stream crossings
Definition: The type of assessment carried out at the stream crossing.
Field Name: assessment_type
Data Type: varchar(64)
Assessment Type Code
Feature Type: Stream crossings
Definition: The type of assessment carried out at the stream crossing.
Field Name: assessment_type_code
Data Type: integer
Code Name Description 1 Rapid A rapid assessment has been conducted at the crossing. 2 Full A full assessment has been conducted at the crossing. 3 Other An assessment has been conducted at the crossing, but the type of assessment is different than those defined in this table. 4 Imagery The crossing has been reviewed through available satellite imagery, but has not been visited in the field. 5 Modelled The crossing has not been visited in the field or reviewed in satellite imagery. 6 Inventory The feature is updated from existing inventories that contain data that cannot be considered assessment data
Barrier Assessment Status
Feature Type: Stream crossings
Definition: Indicates whether the barrier has been assessed.
Field Name: barrier_assessment_status
Data Type: varchar(64)
Barrier Assessment Status Code
Feature Type: Stream crossings
Definition: Indicates whether the barrier has been assessed.
Field Name: barrier_assessment_status_code
Data Type: integer
Code Name Description 1 assessed 2 not assessed
Barrier Identifier
Feature Type: Stream crossings
Definition: Unique identifier for the stream crossing
Field Name: cabd_id
Data Type: uuid
Barrier Removed
Feature Type: Stream crossings
Definition: Indicates whether the barrier has been removed or decommissioned.
Field Name: barrier_removed
Data Type: varchar(64)
Barrier Removed Status Code
Feature Type: Stream crossings
Definition: Indicates whether the barrier has been removed or decommissioned.
Field Name: barrier_removed_code
Data Type: integer
Code Name Description 1 yes 2 no 99 unknown
Constriction
Feature Type: Stream crossings
Definition: How the width of the stream crossing (including all of its structures) compares to the width of the natural stream channel
Field Name: constriction
Data Type: character varying
Constriction Code
Feature Type: Stream crossings
Definition: Code referencing how the width of the stream crossing (including all of its structures) compares to the width of the natural stream channel
Field Name: constriction_code
Data Type: integer
Code Name Description 1 severe 2 moderate 3 spans only bankfull/active channel 4 spans full channel and banks
Crossing Comments
Feature Type: Stream crossings
Definition: Brief comments about any aspect of the overall stream crossing assessment that warrants additional information.
Field Name: crossing_comments
Data Type: character varying
Crossing Condition
Feature Type: Stream crossings
Definition: Stream crossing condition
Field Name: crossing_condition
Data Type: character varying
Crossing Condition Code
Feature Type: Stream crossings
Definition: Code referencing the stream crossing condition
Field Name: crossing_condition_code
Data Type: integer
Code Name Description 1 new 2 ok 3 poor 4 failing 99 unknown
Crossing Type
Feature Type: Stream crossings
Definition: Type of stream crossing
Field Name: crossing_type
Data Type: character varying
Crossing Type Code
Feature Type: Stream crossings
Definition: Code referencing the type of stream crossing
Field Name: crossing_type_code
Data Type: integer
Code Name Description 1 bridge 2 culvert 3 multiple culvert 4 ford 5 no crossing 6 removed crossing 7 buried stream 8 inaccessible 9 partially inaccessible 10 no upstream channel 11 bridge adequate 99 unknown
Date Observed
Feature Type: Stream crossings
Definition: Date that the stream crossing was evaluated.
Field Name: date_observed
Data Type: date
Downstream Bankfull Width (m)
Feature Type: Stream crossings
Definition: Measure of the active stream channel width downstream of the stream crossing at bankfull flow, the point at which water completely fills the stream channel and where additional water would overflow into the floodplain.
Field Name: downstream_bankfull_width_m
Data Type: numeric
Downstream Bankfull Width Confidence
Feature Type: Stream crossings
Definition: Confidence of the assessor for the downstream bankfull width measurement, based on their experience with its measurement and whether sufficient criteria were met in their measurements
Field Name: downstream_bankfull_width_confidence
Data Type: character varying
Downstream Bankfull Width Confidence Code
Feature Type: Stream crossings
Definition: Code referencing the confidence of the assessor for the downstream bankfull width measurement
Field Name: downstream_bankfull_width_confidence_code
Data Type: integer
Code Name Description 1 high 2 low
Downstream Channel Depth (m)
Feature Type: Stream crossings
Definition: Average depth (in m) of the natural channel downstream of the stream crossing (unaffected by the crossing).
Field Name: downstream_channel_depth_m
Data Type: numeric
Downstream Channel Width (m)
Feature Type: Stream crossings
Definition: Average width (in m) of the natural channel downstream of the stream crossing (unaffected by the crossing). This is a measure of the active stream channel width at bankfull flow, the point at which water completely fills the stream channel and where additional water would overflow into the floodplain or marsh. When possible, this is an average of measurements taken at three locations down‐gradient of the crossing.
Field Name: downstream_channel_width_m
Data Type: numeric
Downstream Scour Pool Width (m)
Feature Type: Stream crossings
Definition: Maximum width of the scour pool (in m) directly down‐gradient of the stream crossing. If no scour pool is present, the pool width should be recorded as the same as the channel width.
Field Name: downstream_scour_pool_width_m
Data Type: numeric
Downstream Tidal Range (m)
Feature Type: Stream crossings
Definition: An estimate of the difference between low tide and high tide elevations (in m) at the downstream end of the stream crossing. Based on indicators of high water at the site such as water stains (preferred) on nearby structures or vegetation, or wrack lines.
Field Name: tidal_downstream_tidal_range_m
Data Type: numeric
Feature Type
Feature Type: Stream crossings
Definition: The type of feature the data point represents
Field Name: feature_type
Data Type: text
Flow Condition
Feature Type: Stream crossings
Definition: Flow condition at the time of assessment
Field Name: flow_condition
Data Type: character varying
Flow Condition Code
Feature Type: Stream crossings
Definition: Code referencing the flow condition at the time of assessment
Field Name: flow_condition_code
Data Type: integer
Code Name Description 1 dewatered 2 unusually low 3 typical low flow 4 moderate flow 5 high flow
Include in ACT
Feature Type: Stream crossings
Definition: Indicates whether the snapped_ncc field is populated
Field Name: include_in_act
Data Type: boolean
Latitude
Feature Type: Stream crossings
Definition: Latitude of point location of stream crossing in decimal degrees; the point location is only an approximation of the actual stream crossing location.
Field Name: latitude
Data Type: double precision
Lead Observer
Feature Type: Stream crossings
Definition: Name or initials of the assessment team leader responsible for the quality of the data collected
Field Name: lead_observer
Data Type: character varying
Location
Feature Type: Stream crossings
Field Name: geometry
Data Type: geometry
Location Description
Feature Type: Stream crossings
Definition: Optional description of the stream crossing location to help assessors identify the exact location
Field Name: location_description
Data Type: character varying
Longitude
Feature Type: Stream crossings
Definition: Longitude of point location of stream crossing in decimal degrees; the point location is only an approximation of the actual stream crossing location.
Field Name: longitude
Data Type: double precision
Low Tide Prediction
Feature Type: Stream crossings
Definition: Nearest estimated time of low tide for the site based on an appropriate tide chart
Field Name: tidal_low_tide_prediction
Data Type: time without time zone
Municipality
Feature Type: Stream crossings
Definition: The municipality the stream crossing is located in
Field Name: municipality
Data Type: character varying
NHN Watershed ID
Feature Type: Stream crossings
Definition: A code referencing the work unit ‘Dataset Name’ from the National Hydrographic Network (NHN) that the feature is located in.
Field Name: nhn_watershed_id
Data Type: varchar(7)
NHN Watershed Name
Feature Type: Stream crossings
Definition: The name of the NHN sub-sub drainage area.
Field Name: nhn_watershed_name
Data Type: varchar(500)
Number of Railway Tracks
Feature Type: Stream crossings
Definition: Number of railway tracks
Field Name: num_railway_tracks
Data Type: integer
Original Assessment ID
Feature Type: Stream crossings
Definition: The original id used by another program to refer to the stream crossing, where available. This does not replace the unique barrier identifier in the CABD.
Field Name: original_assessment_id
Data Type: character varying
Passability Status
Feature Type: Stream crossings
Definition: The degree to which the structure acts as a barrier to fish in the upstream direction.
Field Name: passability_status
Data Type: character varying
Passability Status Code
Feature Type: Stream crossings
Definition: Code referencing the degree to which the structure acts as a barrier to fish in the upstream direction.
Field Name: passability_status_code
Data Type: integer
Code Name Description 1 Barrier The structure acts as a hard barrier to all aquatic species. If the only upstream passage measure indicated for a structure is trap and truck, the structure is marked as a Barrier until other information indicates it should be a Partial Barrier. 2 Partial Barrier The structure may act as a barrier to some aquatic species but may also be passable to others. Structures that include a fishway are marked as a Partial Barrier as the fishway is assumed to improve passage at the site. 3 Passable The structure does not act as a barrier to aquatic species. Structures that are decommissioned or removed are marked as Passable, assuming decommissioned or removed structures no longer impact fish passage. 4 Unknown The passability status of the structure is unknown. 5 NA - No Structure Not applicable - there is no structure at this location. 6 NA - Decommissioned/ Removed Not applicable - the structure has been decommissioned or removed.
Photo Id Downstream
Feature Type: Stream crossings
Definition: ID of photo showing the stream channel downstream of the stream crossing
Field Name: photo_id_downstream
Data Type: uuid
Photo Id Inlet
Feature Type: Stream crossings
Definition: ID of photo taken at the stream crossing inlet
Field Name: photo_id_inlet
Data Type: uuid
Photo Id Other
Feature Type: Stream crossings
Definition: ID of photo(s) showing any other relevant features of the stream crossing or channel characteristics
Field Name: photo_id_other
Data Type: uuid
Photo Id Outlet
Feature Type: Stream crossings
Definition: ID of photo taken at the stream crossing outlet
Field Name: photo_id_outlet
Data Type: uuid
Photo Id Upstream
Feature Type: Stream crossings
Definition: ID of photo showing the stream channel upstream of the stream crossing
Field Name: photo_id_upstream
Data Type: uuid
Province/Territory Code
Feature Type: Stream crossings
Definition: The province or territory the dam is located in.
Field Name: province_territory_code
Data Type: varchar(2)
Code Name Description ab Alberta bc British Columbia mb Manitoba nb New Brunswick nl Newfoundland and Labrador ns Nova Scotia nt Northwest Territories nu Nunavut on Ontario pe Prince Edward Island qc Quebec sk Saskatchewan us United States yt Yukon
Province/Territory Name
Feature Type: Stream crossings
Definition: The province or territory the dam is located in.
Field Name: province_territory
Data Type: varchar(32)
Railway Operator
Feature Type: Stream crossings
Definition: Operator of the railway
Field Name: railway_operator
Data Type: character varying
Railway Status
Feature Type: Stream crossings
Definition: Operating status of the railway
Field Name: railway_status
Data Type: character varying
Road Class
Feature Type: Stream crossings
Definition: Classification of the road, typically describing the type of service the road is intended to provide
Field Name: road_class
Data Type: character varying
Road Fill Height (m)
Feature Type: Stream crossings
Definition: Height of fill material between the top of the stream crossing structure(s) and the road surface
Field Name: road_fill_height_m
Data Type: numeric
Road Flooded at High Tide
Feature Type: Stream crossings
Definition: Indicates whether the road is likely to be flooded at high tide, based on indicators of high water at the site such as water stains (preferred) on nearby structures or vegetation, or wrack lines
Field Name: tidal_road_flooded_high_tide
Data Type: boolean
Road Name
Feature Type: Stream crossings
Definition: Name of the road or other transportation infrastructure that uses the stream crossing
Field Name: road_name
Data Type: character varying
Road Surface
Feature Type: Stream crossings
Definition: Type of road surface
Field Name: road_surface
Data Type: character varying
Road Type
Feature Type: Stream crossings
Definition: Type of road or other transportation infrastructure that uses the stream crossing
Field Name: road_type
Data Type: character varying
Road Type Code
Feature Type: Stream crossings
Definition: Code referencing the type of road or other transportation infrastructure that uses the stream crossing
Field Name: road_type_code
Data Type: integer
Code Name Description 1 multilane 2 paved 3 unpaved 4 driveway 5 road 6 resource road 7 trail 8 railroad
Salinity (ppt)
Feature Type: Stream crossings
Definition: Water salinity at the stream crossing in parts per thousands (ppt)
Field Name: tidal_salinity_ppt
Data Type: integer
Site Type
Feature Type: Stream crossings
Definition: Indicates if the site is in a tidal zone or non-tidal zone
Field Name: site_type
Data Type: character varying
Site Type Code
Feature Type: Stream crossings
Definition: Code referencing whether the site is in a tidal zone or non-tidal zone
Field Name: site_type_code
Data Type: integer
Code Name Description 1 tidal 2 nontidal 99 unknown
Strahler Order
Feature Type: Stream crossings
Definition: Strahler stream order of the stream in which the stream crossing is recorded
Field Name: strahler_order
Data Type: integer
Stream Name
Feature Type: Stream crossings
Definition: Name of river/stream in which the stream crossing is recorded
Field Name: stream_name
Data Type: character varying
Stream Type
Feature Type: Stream crossings
Definition: Type of tidal river or stream at the stream crossing
Field Name: tidal_stream_type
Data Type: character varying
Stream Type Code
Feature Type: Stream crossings
Definition: Code referencing the type of tidal river or stream at the stream crossing
Field Name: tidal_stream_type_code
Data Type: integer
Code Name Description 1 salt marsh creek 2 salt/brackish flow-through stream 3 freshwater tidal
Structure Count
Feature Type: Stream crossings
Definition: Number of structures associated with the stream crossing (e.g., multiple culverts)
Field Name: structure_count
Data Type: integer
Tailwater Scour Pool
Feature Type: Stream crossings
Definition: The relative size of the tailwater scour pool in comparison to reference natural pools in a portion of the stream that is outside of the influence of the stream crossing structure
Field Name: tailwater_scour_pool
Data Type: character varying
Tailwater Scour Pool Code
Feature Type: Stream crossings
Definition: Code referencing the relative size of the tailwater scour pool in comparison to reference natural pools in a portion of the stream that is outside of the influence of the stream crossing structure
Field Name: tailwater_scour_pool_code
Data Type: integer
Code Name Description 1 none 2 small 3 large 99 yes-extent unknown
Tide Stage
Feature Type: Stream crossings
Definition: Indicates whether the assessment occurred at low slack tide (no flow), low ebb tide (outgoing tide), low flood tide (incoming tide), or “unknown” if the tide stage was unsure
Field Name: tidal_tide_stage
Data Type: character varying
Tide Stage Code
Feature Type: Stream crossings
Definition: Code referencing whether the assessment occurred at low slack tide (no flow), low ebb tide (outgoing tide), low flood tide (incoming tide), or “unknown” if the tide stage was unsure
Field Name: tidal_tide_stage_code
Data Type: integer
Code Name Description 1 low slack tide 2 low ebb tide 3 low flood tide 4 other 99 unknown
Tide Station
Feature Type: Stream crossings
Definition: Tide chart station used to estimate the time of low tide for the site
Field Name: tidal_tide_station
Data Type: integer
Transport Feature Owner
Feature Type: Stream crossings
Definition: Owner of the transportation infrastructure that uses the stream crossing
Field Name: transport_feature_owner
Data Type: character varying
Upstream Bankfull Width (m)
Feature Type: Stream crossings
Definition: Measure of the active stream channel width upstream of the stream crossing at bankfull flow, the point at which water completely fills the stream channel and where additional water would overflow into the floodplain.
Field Name: upstream_bankfull_width_m
Data Type: numeric
Upstream Bankfull Width Confidence
Feature Type: Stream crossings
Definition: Confidence of the assessor for the upstream bankfull width measurement, based on their experience with its measurement and whether sufficient criteria were met in their measurements
Field Name: upstream_bankfull_width_confidence
Data Type: character varying
Upstream Bankfull Width Confidence Code
Feature Type: Stream crossings
Definition: Code referencing the confidence of the assessor for the upstream bankfull width measurement
Field Name: upstream_bankfull_width_confidence_code
Data Type: integer
Code Name Description 1 high 2 low
Upstream Channel Depth (m)
Feature Type: Stream crossings
Definition: Average depth (in m) of the natural channel upstream of the stream crossing (unaffected by the crossing).
Field Name: upstream_channel_depth_m
Data Type: numeric
Upstream Channel Width (m)
Feature Type: Stream crossings
Definition: Average width (in m) of the natural channel upstream of the stream crossing (unaffected by the crossing). This is a measure of the active stream channel width at bankfull flow, the point at which water completely fills the stream channel and where additional water would overflow into the floodplain or marsh. When possible, this is an average of measurements taken at three locations up‐gradient of the crossing.
Field Name: upstream_channel_width_m
Data Type: numeric
Upstream Scour Pool Width (m)
Feature Type: Stream crossings
Definition: Maximum width of the scour pool (in m) directly up-gradient of the stream crossing. If no scour pool is present, the pool width should be recorded as the same as the channel width.
Field Name: upstream_scour_pool_width_m
Data Type: numeric
Upstream Tidal Range (m)
Feature Type: Stream crossings
Definition: An estimate of the difference between low tide and high tide elevations (in m) at the upstream end of the stream crossing. Based on indicators of high water at the site such as water stains (preferred) on nearby structures or vegetation, or wrack lines.
Field Name: tidal_upstream_tidal_range_m
Data Type: numeric
Vegetation Change
Feature Type: Stream crossings
Definition: Characterization of differences between the vegetative communities above and below the stream crossing
Field Name: tidal_veg_change
Data Type: character varying
Vegetation Change Code
Feature Type: Stream crossings
Definition: Code referencing the characterization of differences between the vegetative communities above and below the stream crossing
Field Name: tidal_veg_change_code
Data Type: integer
Code Name Description 1 comparable vegetative structure and species composition are not noticeably different 2 slightly different differences in vegetative structure and species composition are evident, but small 3 moderately different differences in vegetative structure and species composition are obvious and substantial, but similarities remain 4 very different vegetative structure and species composition are so different that different vegetative communities occur above and below the crossing. This typically occurs where there is a salt marsh below and a freshwater wetland above the crossing. 99 unknown impossible to assess vegetation above and/or below the crossing, due to time of year or lack of a vantage point for observations.
Visible Utilities
Feature Type: Stream crossings
Definition: Record of any utilities at the site that might complicate efforts to replace the stream crossing
Field Name: tidal_visible_utilities
Data Type: character varying
Visible Utilities Code
Feature Type: Stream crossings
Definition: Code referencing any utilities at the site that might complicate efforts to replace the stream crossing
Field Name: tidal_visible_utilities_code
Data Type: integer
Code Name Description 1 overhead wires electrical, telephone or cable wires. 2 water/sewer pipes visible pipes carrying drinking water, storm water or waste water either in or on the substrate, suspended within the structure(s), or otherwise associated with the crossing. 3 gas line pipes for natural gas (often not visible at the surface and only indicated by markers). 4 other other type of utility installation not covered above.
Waterfalls Attributes
Barrier Identifier
Feature Type: Waterfalls
Definition: Unique identifier for waterfall
Field Name: cabd_id
Shapefile Field Name: cabd_id
Data Type: uuid
Comments
Feature Type: Waterfalls
Definition: Unstructured comments about the waterfall.
Field Name: comments
Shapefile Field Name: comments
Data Type: text
Completeness Level
Feature Type: Waterfalls
Definition: The level of information available for the waterfall in the CABD.
Field Name: complete_level
Shapefile Field Name: comp_lvl
Data Type: varchar(32)
Completeness Level Code
Feature Type: Waterfalls
Field Name: complete_level_code
Shapefile Field Name: complvl_c
Data Type: integer
Code Name Description 1 Unverified Record is unverified 2 Minimal Only location is verified 3 Moderate Location and some attributes are known 4 Complete Location and all attributes are known
Fall Height (m)
Feature Type: Waterfalls
Definition: Height of the waterfall in meters.
Field Name: fall_height_m
Shapefile Field Name: height_m
Data Type: double
Fall Name (English)
Feature Type: Waterfalls
Definition: English given or known name of the waterfall.
Field Name: fall_name_en
Shapefile Field Name: wfname_en
Data Type: varchar(512)
Fall Name (French)
Feature Type: Waterfalls
Definition: French given or known name of the waterfall.
Field Name: fall_name_fr
Shapefile Field Name: wfname_fr
Data Type: varchar(512)
Feature Data Source Details
Feature Type: Waterfalls
Definition: Link that identifies the data source for the feature's attributes.
Field Name: datasource_url
Shapefile Field Name: data_src
Data Type: url
Feature Type
Feature Type: Waterfalls
Definition: The type of feature the data point represents.
Field Name: feature_type
Shapefile Field Name: feat_type
Data Type: text
Include in ACT
Feature Type: Waterfalls
Definition: Indicates whether the snapped_ncc field is populated
Field Name: include_in_act
Data Type: boolean
Last Modified
Feature Type: Waterfalls
Definition: The autogenerated date from the attribute data source updates table corresponding to the date that information in a specific row was last updated in the CABD
Field Name: last_modified
Shapefile Field Name: last_mod
Data Type: date
Latitude
Feature Type: Waterfalls
Definition: Latitude of point location of the waterfall in decimal degrees; the point location is only an approximation of the actual waterfall location.
Field Name: latitude
Shapefile Field Name: lat_dd
Data Type: double
Location
Feature Type: Waterfalls
Field Name: geometry
Data Type: geometry
Longitude
Feature Type: Waterfalls
Definition: Longitude of point location of the waterfall in decimal degrees; the point location is only an approximation of the actual waterfall location.
Field Name: longitude
Shapefile Field Name: long_dd
Data Type: double
Municipality
Feature Type: Waterfalls
Definition: The municipality the waterfall is located in.
Field Name: municipality
Shapefile Field Name: muni_name
Data Type: varchar(512)
NHN Watershed ID
Feature Type: Waterfalls
Definition: A code referencing the work unit ‘Dataset Name’ from the National Hydrographic Network (NHN) that the feature is located in.
Field Name: nhn_watershed_id
Shapefile Field Name: nhnws_id
Data Type: varchar(7)
NHN Watershed Name
Feature Type: Waterfalls
Definition: The name of the NHN sub-sub drainage area.
Field Name: nhn_watershed_name
Shapefile Field Name: nhnws_name
Data Type: varchar(500)
Passability Status
Feature Type: Waterfalls
Definition: The degree to which the waterfall acts as a barrier to fish in the upstream direction.
Field Name: passability_status
Shapefile Field Name: pass_stat
Data Type: varchar(32)
Passability Status Code
Feature Type: Waterfalls
Definition: Code referencing the degree to which the structure acts as a barrier to fish in the upstream direction.
Field Name: passability_status_code
Shapefile Field Name: passstat_c
Data Type: integer
Code Name Description 1 Barrier The structure acts as a hard barrier to all aquatic species. If the only upstream passage measure indicated for a structure is trap and truck, the structure is marked as a Barrier until other information indicates it should be a Partial Barrier. 2 Partial Barrier The structure may act as a barrier to some aquatic species but may also be passable to others. Structures that include a fishway are marked as a Partial Barrier as the fishway is assumed to improve passage at the site. 3 Passable The structure does not act as a barrier to aquatic species. Structures that are decommissioned or removed are marked as Passable, assuming decommissioned or removed structures no longer impact fish passage. 4 Unknown The passability status of the structure is unknown. 5 NA - No Structure Not applicable - there is no structure at this location. 6 NA - Decommissioned/ Removed Not applicable - the structure has been decommissioned or removed.
Province/Territory Code
Feature Type: Waterfalls
Field Name: province_territory_code
Shapefile Field Name: pr_terr_c
Data Type: varchar(2)
Code Name Description ab Alberta bc British Columbia mb Manitoba nb New Brunswick nl Newfoundland and Labrador ns Nova Scotia nt Northwest Territories nu Nunavut on Ontario pe Prince Edward Island qc Quebec sk Saskatchewan us United States yt Yukon
Province/Territory Name
Feature Type: Waterfalls
Definition: The province or territory the waterfall is located in.
Field Name: province_territory
Shapefile Field Name: pr_terr
Data Type: varchar(32)
Updates Pending
Feature Type: Waterfalls
Definition: There are updates pending for this feature.
Field Name: updates_pending
Shapefile Field Name: upd_pend
Data Type: boolean
Use for Network Analysis
Feature Type: Waterfalls
Definition: If true, the data point representing this feature is/should be snapped to hydrographic networks for analysis purposes.
Field Name: use_analysis
Shapefile Field Name: useanalysi
Data Type: boolean
Waterbody Name (English)
Feature Type: Waterfalls
Definition: English name of waterbody in which the waterfall is recorded.
Field Name: waterbody_name_en
Shapefile Field Name: wbname_en
Data Type: varchar(512)
Waterbody Name (French)
Feature Type: Waterfalls
Definition: French name of waterbody in which the waterfall is recorded.
Field Name: waterbody_name_fr
Shapefile Field Name: wbname_fr
Data Type: varchar(512)