terraref / reference-data

Coordination of Data Products and Standards for TERRA reference data
https://terraref.org
BSD 3-Clause "New" or "Revised" License
9 stars 2 forks source link

Season 6 Canopy height measured by 98th quantile > 0 on planting date #291

Open dlebauer opened 4 years ago

dlebauer commented 4 years ago

Dataset

All values of canopy_height are > 0 on the planting date in Season 6.

Suggested Correction

This probably requires a fix to the algorithm. It might be caused by the assumption that the 98th quantile is the canopy height, which would not hold for bare ground.

In the mean-time I have marked all measurements during season 6 prior to May 15 as having been found in error.

begin;
update traits set checked = -1, notes = 'heights at date of planning > 0, marked all Season 6 canopy_height data from before canopy started to grow (c. May 15 2018) as failing qa/qc.' where date > date '2018-04-20' and date < date '2018-05-15' and variable_id = (select id from variables where name = 'canopy_height')
commit;

@ZongyangLi please advise.