Data dictionary for mackerel survey (English, French, CSV)
Data dictionary for mackerel survey: 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
Since 1979, Fisheries and Oceans Canada has conducted near-annual mackerel egg surveys in the southern Gulf of St. Lawrence using a standardized methodology. This survey typically takes place over approximately 10 days in June and aims to quantify mackerel eggs, thereby contributing to the stock assessment of the northern contingent. Sampling is conducted at 66 fixed stations arranged in a predefined grid (see included image for station locations and names). Additional stations—following the same sampling methodology—have also been surveyed off of southwestern Newfoundland, eastern Cape Breton and south of Prince Edward Island, as well as in other regions. The mackerel survey is often coordinated with the Atlantic Zone Monitoring Program (AZMP) for the Quebec region, which takes place around the same time using the same research vessel and similar equipment. While these two surveys are distinct, they are coordinated to complement each other. At each station, a tow using 61 cm bongo nets (333 µm mesh size) is towed following a saw-tooth profile through the upper 50 m of the water column. Tows last approximately 10 minutes at a speed of roughly 2.5 knots. These tows target mackerel…
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.
| Column name | Description_EN | Nom de la colonne | Description_FR |
|---|---|---|---|
| PLANKTON_GENERAL_SEQ | Auto generated sequence number. Each row of data has a unique sequence number | SEQ_GENERALE_PLANCTON | Numéro de séquence généré automatiquement. Chaque ligne de données possède un numéro de séquence unique |
| CRUISE_DESCRIPTOR | DFO National reference number provided by Marine environmental Data Section (Archive) | DESCRIPTEUR_MISSION | Numéro de référence national du MPO fourni par la Section des données sur le milieu marin (Archives) |
| START_LAT | Start latitude position of sample in decimal degrees and using EPSG:4326 WGS84 as a coordinate reference system | LAT_DEBUT | Position de latitude de départ de l échantillon en degrés décimaux, selon le système de référence EPSG:4326 WGS84 |
| START_LON | Start longitude position of sample in decimal degrees and using EPSG:4326 WGS84 as a coordinate reference system | LON_DEBUT | Position de longitude de départ de l échantillon en degrés décimaux, selon le système de référence ESPG:4326 WGS84 |
| START_DATE | Start date for event. Format DD/MM/YYYY | DATE_DEBUT | Date de début de l événement. Format JJ/MM/AAAA |
| START_TIME | Start time for event (UTC). Format HHMM | HEURE_DEBUT | Heure de début de l événement (UTC). Format HHMM |
| SOUNDING | Depth of water at site (meters) | SONDAGE | Profondeur de l eau au site (en mètres) |
| COLLECTOR_STATION_NAME | Descritpive name of station (numerical station names ranging from 1.1- 12.1 for primary mackerel grid sampling locations) | NOM_STATION_COLLECTEUR | Nom descriptif de la station (noms numériques des stations allant de 1.1 à 12.1 pour les sites d échantillonnage primaire de la grille de maquereau) |
| COLLECTOR_EVENT_ID | Number assigned to a station during data collection for a given mission | ID_EVENEMENT_COLLECTEUR | Numéro attribué à une station lors de la collecte des données pour une mission spécifique |
| START_DEPTH | Start depth of sample collection in meters | PROF_DEBUT | Profondeur de début de l échantillonnage (en mètres) |