search

dfo-pacific-science / data-stewardship-unit

A quarto project that generates that DSU website via Github actions
https://dfo-pacific-science.github.io/data-stewardship-unit/
0 stars 0 forks source link

Update Commercial Salmon Catch Query to report on licence areas separately (e.g., gill net D/E) #40

Closed AnnaD-M closed 3 months ago

Br-Johnson commented 3 months ago

Recreate this part of the opening query:

SELECT
    CASE ol.lic_lic_id
        WHEN 5328 THEN 'Seine A'
        WHEN 5330 THEN 'Seine B'
        WHEN 5332 THEN 'Gillnet C'
        WHEN 5334 THEN 'Gillnet D'
        WHEN 5336 THEN 'Gillnet E'
        WHEN 5338 THEN 'Troll F'
        WHEN 5340 THEN 'Troll G'
        WHEN 5342 THEN 'Troll H'
        ELSE 'Other'
    END AS gear,
Br-Johnson commented 3 months ago

Added a new column called 'license type' to the qry_commercial_catch table