search

envisionnw / invasives_rpts

invasive species reporting
0 stars 0 forks source link

AverageCover Appears Not to include Dead Species #59

Closed envisionnw closed 7 years ago

envisionnw commented 7 years ago

Issue by NCPN Wednesday Jun 28, 2017 at 13:58 GMT _Originally opened as https://github.com/NCPN/invasives_rpts/issues/59_

CARE-2015-Oak Creek & Scenic Drive AverageCover & SE look correct. However, the Average Cover for Cathedral Valley does not match. SE value is pretty close. Cathedral Valley is the only route with dead species for CARE 2015. In the result table that is generated by the reporting tool, all the species are alive. What is happening to the dead species? Does this has anything to do with the discrepancy. Expect to see another row in the table for the dead species.

See Excel sheets.

Also compared the values for some other park/year combinations, mainly to see if there was a pattern of our values not matching when there were dead species. Some other cases support this pattern, but also found some values that didn't match even when there were no dead species.

envisionnw commented 7 years ago

Issue appears related to GROUP BY clauses and in some instances JOINs bringing in information like RouteAverageCover. Updates include revisions to deviation, deviation aggregation, std deviation, and std error queries. Values now mesh w/ *.xls expectations.

envisionnw commented 7 years ago

Closed w/ Version 2.1.0.9023