include Market_Code and Negear codes

[andybeet]

Can we include MARKET_CODE in the final product as well as NEGEAR codes?
MARKET_CODE is a column in stock efficiency table whereas MKTCAT is integer code in cfspp
Then aggregate as needed

[slucey]

Are MARKET_CODE and MKTCAT the same?

[andybeet]

No MKTCAT is integer, unsure what each digit represents.
MARKET_CODE is character, representing size eg "LG","XL","UN" etc.
I'm sure they are mapped but unsure how.
I can check ADIOS docs

[slucey]

OK...we can definitely map those codes. MKTCAT is currently carried over in get_comland_data on Sean_overhaul branch.

[andybeet]

We might also want to think about pulling directly from stockeff tables. Will speed up the pull time greatly.

[slucey]

Unfortunately the stockeff table is missing the sppvalue field. But maybe that is a simple fix if SSB has a look up table of prices.

[andybeet]

So there is a table in stockeff called mv_cf_species_c which maps NESPP4 (MKTCAT) to MARKET_CODE.
The only potential problem is that each individual may need permissions to access this table, which would make it useless in a package for general use. Looking into that

Edit: a better solution comlandr::get_species_itis pulls data from SPECIES_ITIS_NE table which maps NESPP4 codes with MARKET_CODE. Just need to adjust the function to be able to search using NESPP4 codes

[andybeet]

@slucey

Can now pull MARKET_CODE from SPECIES_ITIS_NE table based on NESPP4 code

comlandr::get_species_itis(channel, species = 814, nameType = "NESPP4")
comlandr::get_species_itis(channel, species = "0814", nameType = "NESPP4")

Result:

$data
# A tibble: 1 x 15
  NESPP4 SPECIES_ITIS COMMON_NAME  SCIENTIFIC_NAME UNIT_OF_MEASURE GRADE_CODE GRADE_DESC  MARKET_CODE MARKET_DESC CF_LNDLB_LIVLB CF_RPTQTY_LNDLB
  <chr>  <chr>        <chr>        <chr>           <chr>           <chr>      <chr>       <chr>       <chr>                <dbl>           <dbl>
1 0814   164712       COD,ATLANTIC GADUS MORHUA    LB              23         GUTTED, HE~ SK          SCROD                 1.17               1
# ... with 4 more variables: MIN_PRICE <dbl>, MAX_PRICE <dbl>, PARTNER_ID <chr>, NESPP4_FLAG <chr>

Just need to incorporate into comlandr data pull/aggregation code

[slucey]

I'll add this into the main work flow for comlandr