`get.opp.files` doesn't properly remove outliers

[seaflow-uw]

`get.opp.files` doesn't properly remove outliers

[ctberthiaume]

This can be pused down to SQL, and probably should be. One major advantage of a declarative language like SQL is these kinds of matching bugs don't happen. Rough cut at a SQL query to only get OPP files that are in the SFL table and have data in all three quantiles. Could add another join to outliers table too.

SELECT sfl.date AS date,
       opp.*
FROM sfl
INNER JOIN opp
ON sfl.file == opp.file
INNER JOIN
(
  SELECT file FROM opp
  WHERE opp_count > 0
  GROUP BY file
  HAVING count(file) == 3
) AS o
ON sfl.file == o.file
ORDER BY sfl.date ASC;

[ctberthiaume]

Fixed in 1e8ef17.