Demethyl hexazinone B/Didemethyl hexazinone F - same CAS number?

[limnoliver]

I think these might be the same compounds, and something happens in the merge process where they get repeated as having the same CAS number but different chem names. Therefore, the data gets repeated with the same concentration vals.

If you make target chemicalSummary_conc and then subset using the CAS number chemicalSummary_conc[grep('56611-54-2', chemicalSummary_conc$CAS, ignore.case = T), ] you can see the duplicate values, which only occur for Maumee and IHC (maybe only places it is detected?).

There was a place that Laura had changed the name and I had commented out. Will try redoing with Laura's old changes and see what happens.

Steve and I also chatted about this - e.g., thought at the time this compound was measured using different methods, but maybe this is just a merge issue?

[limnoliver]

Put Laura's original name changes back in, did not seem to fix duplicate measure with different name issue. Continue investigating...

[limnoliver]

Okay - seems that the pesticide schedule reports these two compounds with separate pCodes - and they do have different reported values. Only pCode 68566 (Demethyl hexazinone B) is ever detected, so I think for now I will drop pCode 68574 early in the process so there are no duplicate CAS issues.

[srcorsi-USGS]

Pretty odd that they both have the same CAS num in the NWQL schedule. I think you have the solution since one of them is not detected. It still might be worth a note to Mark Sandstrom to see what his take on it is. I wonder if that is a mistake in the NWQL schedule info.