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.
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.
| TableName | FieldName | Description |
|---|---|---|
| 1-Headers | HKey | Primary key |
| 1-Headers | Survey | Decimal minutes of longitude at end of transect (shallow) |
| 1-Headers | Region | HG: Haida Gwaii, NCC: North central coast, QCS: Queen Charlotte Strait, WCVI: west coast Vancouver Island, SoG: Strait of Georgia |
| 1-Headers | Year | Year data collected |
| 1-Headers | Month | Month data collected |
| 1-Headers | Day | Day data collected |
| 1-Headers | TideStation | Tide Station used to correct depths for the transect |
| 1-Headers | Transect | Transect number |
| 1-Headers | QuadratSkipping | 1. if all quadrats surveyed (transect <150m); 2. if every second quadrat surveyed (150m < Transect <300m); 3. if every third quadrat surveyed (transect > 300m) |
| 1-Headers | Tr_Length | Transect length in meters |