I am encountering an issue with not being able to pull quillback rockfish bio data from the triennial survey using pull_bio. For the 2021 quillback assessment, I was able to pull 48 lengths of quillback (data was pulled July 30, 2020), however currently, the function throws an error and doesn't return anything.
I was able to talk with the data warehouse people (Jim Fellows) and can confirm that quillback bio data exist for the triennial survey. The issue is that quillback data only exist in the trawl.triennial_length_fact table, and not in the trawl.individual_fact table. Therefore, line 125 in pull_bio results in a try-error, and the code stops at lines 127-131
However, the pull in line 173 works and can pull the available quillback bio data.
I am encountering an issue with not being able to pull quillback rockfish bio data from the triennial survey using pull_bio. For the 2021 quillback assessment, I was able to pull 48 lengths of quillback (data was pulled July 30, 2020), however currently, the function throws an error and doesn't return anything.
I was able to talk with the data warehouse people (Jim Fellows) and can confirm that quillback bio data exist for the triennial survey. The issue is that quillback data only exist in the trawl.triennial_length_fact table, and not in the trawl.individual_fact table. Therefore, line 125 in pull_bio results in a try-error, and the code stops at lines 127-131
However, the pull in line 173 works and can pull the available quillback bio data.