SPPVALUE missing from 2020

[andybeet]

since 2020 there are many thousand records (~43,000) that do not contain SPPVALUE. They are NA
This is the CAMS data period.

Reached out to stockeff group. May need to reassess and reach out to CAMS

So it turns out there is a data_source column in CAMS. Both of CAMSAA_DLR and CAMSAA_VTR have missing SPPVALUE.
May need to read through the CAMS docs to see why the DLR data would not have SPPVALUE.

CAMS docs

[sgaichas]

Yes I see that in the comland_raw pull: looks like about 10% of post 2020 records are missing SPPVALUE; at least a couple appear to have 0.00000000 for SPPLIVMT

460876 records in comland_raw |> dplyr::filter(YEAR>2019 & !is.na(SPPVALUE))
42359 records in comland_raw |> dplyr::filter(YEAR>2019 & is.na(SPPVALUE))