pfmc-assessments/nwfscSurvey

Add function for NOAA DSCRTP to pull coral and sponge records from Data Warehouse

Opened this issue · 2 comments

Add function, similar to PullCatch.fn to pull the following taxonomic groups from the Data Warehouse trawl_catch_fact table:

  1. All corals and sponges
  2. All corals
  3. All sponges (Phylum Porifera)
  4. All sea pens (Order Pennatulacea)

Curt Whitmire has started creating an R function and will work with other contributors to test and ultimately merge into this package.

@Curt-Whitmire-NOAA This is fantastic. Once you have this sketched out, I would love to collaborate to see how we could incorporate this into the main functions. Currently, I am thinking of having a single function to pull a data type (either catch or biological samples) and then with that function have switches or calls to other functions that will define parameters based on the type of data requested (normal survey data, all data including non-standard surveys, coral and sponge data). Hopefully this will limit duplicate code across similar functions and create a streamline data retrieval process.

@chantelwetzel-noaa , that sounds like a great plan! I was wondering how best to offer the user different options for pulling related datasets, and I like your idea of "switches" or calls to other functions. I'll share what I have so far with you soon, but so far I've only copied and modified the PullCatch.fn to pull additional fields that are required for the DSCRTP national database.