search

NCPN / invasives_rpts

invasive species reporting
0 stars 2 forks source link

Average Cover not Calculated Properly for Transect_Data query #54

Closed blcampbell-NCPN closed 7 years ago

blcampbell-NCPN commented 7 years ago

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.

blcampbell-NCPN commented 7 years ago

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