search

afsc-gap-products / data-requests

An empty repo for tracking requests for GAP data
0 stars 0 forks source link

Data request: all NBS hauls #59

Closed BobMcCy closed 1 year ago

BobMcCy commented 1 year ago

Please produce an SQL script that will select all GAP bottom-trawl survey hauls in the NBS (2010, 2017, 2018, 2019, 2021, 2022). I intend to use the script to calculate CPUEs for all benthic invertebrate taxa, with some exploration about the most appropriate taxonomic levels. If you prefer to produce the data, I require 0 catches and would like all fields from the haul and catch tables included. Thank you! Bob McConnaughey

EmilyMarkowitz-NOAA commented 1 year ago

Hi Bob! Yes, while these files have not yet been posted on FOSS (soon!), the NBS 2010, 2017, 2019, 2021, and 2022 (Note: not 2018) data are available to you on Oracle in the RACEBASE_FOSS schema! Check out the documentation for this here.

I'm sure you already know this, @BobMcCy, but the 2018 NBS data are not included in the FOSS dataset because they are not considered part of our standard, used for design-based-indices data. @Duane-Stevenson-NOAA: can I share the same data and notes I prepared for data request #43 for the 2018 NBS data?

Duane-Stevenson-NOAA commented 1 year ago

Great! Thanks, Em!

Duane

On Tue, Feb 21, 2023 at 2:19 PM Em Markowitz (NOAA) < @.***> wrote:

Hi Bob! Yes, while these files have not yet been posted on FOSS (soon!), the NBS 2010, 2017, 2019, 2021, and 2022 (Note: not 2018) data are available to you on Oracle in the RACEBASE_FOSS schema! Check out the documentation for this here https://github.com/afsc-gap-products/gap_public_data#access-data-via-oracle .

I'm sure you already know this, @BobMcCy https://github.com/BobMcCy, but the 2018 NBS data are not included in the FOSS dataset because they are not considered part of our standard, used for design-based-indices data. @Duane-Stevenson-NOAA https://github.com/Duane-Stevenson-NOAA: can I share the same data and notes I prepared for data request #43 https://github.com/afsc-gap-products/data-requests/issues/43 for the 2018 NBS data?

— Reply to this email directly, view it on GitHub https://github.com/afsc-gap-products/data-requests/issues/59#issuecomment-1439163696, or unsubscribe https://github.com/notifications/unsubscribe-auth/ANKDWARKWL6WYXIFDXUBSP3WYU5NHANCNFSM6AAAAAAVDKUOSM . You are receiving this because you were mentioned.Message ID: @.***>

-- Duane Stevenson, Ph.D. Supervisory Fish Biologist Groundfish Assessment Program NMFS, Alaska Fisheries Science Center

EmilyMarkowitz-NOAA commented 1 year ago

Perfect! Here are the 2018 NBS data (plus a bit more) and metadata.

Anything else I can provide you with, @BobMcCy?

BobMcCy commented 1 year ago

No thank you Em!  I'll pull the 2018 data with sqlplus and compare my results with the data you've posted.

I appreciate your help very much...Bob

EmilyMarkowitz-NOAA commented 1 year ago

Happy to help! I'll close the issue for now but feel free to reopen if you need anything else!