ADFG Salmon Escape and Return Data Retrieval

[sandysum]

One of our working groups is seeking data on complete salmon escapement and recruitment to determine the productivity of each year. This is tricky with salmon because for one spawning year, the juvenile fish leave the rivers and then come back as adults over the course of many years.

Update 11 March: Have pulled in and merged two tables from the following ADFG manuscripts:

• 15-03, P97 (http://www.adfg.alaska.gov/FedAidPDFs/FMS15-03.pdf)
• 13-11, P40 (https://www.adfg.alaska.gov/static/regulations/regprocess/fisheriesboard/pdfs/2013-2014/kodiak/fms13-11.pdf)

  Notes & next steps:

• 13-11 data contains breakdown of age by salmon recruitment, I have not added this into the merged table as it would distort the consistency of cell values for data from the other manuscript (15-03). Will find a way to incorporate this next Monday when I get in.
• 15-02 (http://www.adfg.alaska.gov/FedAidPDFs/FMS15-02.pdf)

Within this report, appendices A3 (p22), B3(p28-30. Early run sockeye), and B4 (p31-33. Late-run sockeye salmon) would be very helpful to have.

Will pull in these tables and merge with main dataset next Monday.

• Will also run through the other manuscripts for similar tables.

[sandysum]

Updates

Two tables pulled from FMS 15-02, 15-03 and 13-11.

1. Combined salmon escapement and return data from the three manuscripts
2. Combined late and early run brood data from FMS 15-02

Have left the data mostly untouched with the breakdown of ages as they were presented in the PDF.

Notes

Objective is to retrieve a measure of productivity of salmon spawners for a given year. Measurement metric is R/S, total return per spawner.

Total return is estimated as the total harvest (get caught by commercial or recreational fisheries) and total escapement (does not get caught).

Look out for total return, R/S values in reports.

Next steps

More reports coming in and I am looking through them for the above mentioned: R/S and total return data

• FMR 13-44: Kodiak mgmt area
• FMR 14-16: North AK peninsula
• FMR 14-15: South AK peninsula
• FMR 14-33: Aleutian Is. & Atka Amlia Is.
• FMS 11-05
• FMS 15-04

After all the tables have been finalised I will get started on metadata creation.

[sandysum]

We have to look into 15-04 from P54 to 72 to identify tables that match "SRA" --> tables that match SRA are referenced in corresponding papers. Have filtered out only reports referencing SRA and saved them in attached text file(under column "ref"). Next step is to go to these reports cited in P8 of 15-04 and pull those tables out. 15-04_TablesToRetrieve.txt

[couture322]

Pulled out additional tables from FMR 13-11 (sockeye data for various locations) and started to look into the 'more reports' list above. Looks like 13-44 doesn't have anything we want but 14-16 could have a lot of data. I'll pick up with these and Rich's list from 15-04 next time.

[sandysum]

Uploaded the retrieval list on a shared google sheet for ease of use and collaboration. Also added a comment column and reference links in the second tab so we can just click the link and go to referenced report from there! https://docs.google.com/spreadsheets/d/1KyRu-d2mhEgIGS-N1FBDqGTCvJYqwfKZSvblVbm6zxw/edit?usp=sharing

[sandysum]

Based on most common ways data is presented in manuscripts, have defined 3 main formats for merging data, they differ by header titles and how detailed the breakdown is:

• T1: No return ages
• T2: Return ages from 3-7
• T3: Left and return ages separated by decimal point i.e. (1.4, 3.2...4.3)

Extracted FMS10-09 (Nemeth et al 2010) and FMS06-03 (Nelson et al 2006) on 22/03/2016, loads of good data belonging to T3 type format above. Need to check with Rich if we want data from Yukon Region (upper and lower).