Data Dictionary (English, French, CSV)

Data Dictionary: English/French CSV file you can open as a table, filter, chart and export up to 10,000 rows. From Fisheries and Oceans Canada, updated Mar 2026.

Format
CSV
Access
Table on demand (prepared when opened)
Publisher-reported update
2026-03-24

The purpose of the survey is to document and record habitat types and associated algae and marine invertebrate species in a variety of habitat types. Transect locations are randomly selected throughout the study area, which rotates between the north and south coasts of British Columbia on a biannual basis. Transects are laid perpendicular to the shoreline. A team of two divers swim the transect with data sheets to collect habitat, algae and marine invertebrate data as detailed below in the methods section. Data is keypunched in an MS Access database that can be queried for species observations and environmental information. This dataset includes three tables pulled from the original database containing observations by species, observations by quadrat, and additional header information for each observation. All three tables can be linked by the field HKey. Three lookup tables are included as well, one for algae, one for invertebrates, and one for substrates.

Access original file

Data overview

Formats
CSV
File languages
English, French
Available actions
Explore table (prepared automatically) · Access original file

Sample rows

The first 10 rows, as CanQuery read them from the start of the publisher's file on 2026-11-04.

TableNameFieldNameDescription
1-HeadersHKeyPrimary key
1-HeadersSurveyDecimal minutes of longitude at end of transect (shallow)
1-HeadersRegionHG: Haida Gwaii, NCC: North central coast, QCS: Queen Charlotte Strait, WCVI: west coast Vancouver Island, SoG: Strait of Georgia
1-HeadersYearYear data collected
1-HeadersMonthMonth data collected
1-HeadersDayDay data collected
1-HeadersTideStationTide Station used to correct depths for the transect
1-HeadersTransectTransect number
1-HeadersQuadratSkipping1. if all quadrats surveyed (transect <150m); 2. if every second quadrat surveyed (150m < Transect <300m); 3. if every third quadrat surveyed (transect > 300m)
1-HeadersTr_LengthTransect length in meters

Official sources and licences

Related open data