cross check the battle and clear RST with EDI to confirm all runs

[alvizek]

one final check to make sure we have all the runs for battle and clear

[ErinCain]

Looks like for the same date ranges Battle EDI version has: fall late-fall spring winter 1717 633 28546 363

And our data has (qc markdown): fall late fall spring winter 1443 635 29396 361

but standard catch pretty different - are we using the right run? : fall late fall not recorded spring winter 1434 438 468 7614 188

[ErinCain]

And on Clear things look similar - at least in the original QC markdown edi data: fall late-fall spring winter 221564 13850 64824 185

our data: fall late fall spring winter 223307 13808 65368 186

But then it looks like we loose a bunch by the time we get to standard catch... standard_catch: fall late fall not recorded spring winter 41511 5656 905 11803 179

[alvizek]

Next steps

• check if the standard format is using the wrong run or why it is so different that raw. there could also be a messy join happening when adding catch = 0

[ErinCain]

I think what is happening is that the high values showing up on EDI and in qc markdown include catch = 0 rows. In standard catch we do not include those rows