envisionnw / invasives_rpts

invasive species reporting
0 stars 0 forks source link

Average Cover not Calculated Properly for Transect_Data query #54

Closed envisionnw closed 7 years ago

envisionnw commented 7 years ago

Issue by NCPN Tuesday Jun 13, 2017 at 17:13 GMT _Originally opened as https://github.com/NCPN/invasives_rpts/issues/54_


Transect_Data query - average cover issue: Average cover is not being calculated correctly in some cases. See spreadsheets for examples.

Not been able to find any patterns yet. In some cases, it looks like the reporting tool is displaying the percent cover sum rather than the average cover, but this is not always the case. Checked some transects that had fewer than 3 quadrats sampled and some that had dead species. Some of the average covers are correct, but some are not.

envisionnw commented 7 years ago

Issue relates to number of sampled quadrats which differs between provided queries and Transect_Select_Count values.