Data-rich specimen stats

[mkoo]

For the portal stats, include counts of how many specimens have: 1) tissues; 2) mappable; 3) media; 4) all three; 5) tissues and media. This could be extended to a per collection basis but at least network wide to show that not all specimens are equal.

related to portal stats issues #524

[tucotuco]

I did some investigation and think we could actually make some immensely rich stats for the portal by using the BigQuery API. We could also use the BigQuery API to get exact matching record counts for queries.

I created an adaptation of Google example code at https://gist.github.com/tucotuco/fcfb38f38c92f0fefe5a461248afc481.

[mkoo]

this is cool! would it be feasible on a collection basis? I imagine
institutions might want a 'data-health' report every once in a while, or on
demand.

On Tue, Aug 23, 2016 at 12:03 PM, John Wieczorek notifications@github.com
wrote:

I did some investigation and think we could actually make some immensely
rich stats for the portal by using the BigQuery API. We could also use the
BigQuery API to get exact matching record counts for queries.

I created an adaptation of Google example code at https://gist.github.com/
tucotuco/fcfb38f38c92f0fefe5a461248afc481.

—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub
#626 (comment), or mute
the thread
https://github.com/notifications/unsubscribe-auth/ACZ_0UjBEVWIAclZzRTq8Wqs-zITM6pgks5qi0QZgaJpZM4JrGj7
.

[tucotuco]

Definitely! See comment on issue #524

[dbloom]

This would be great. Is this something that Javi will have time for, or is
it something we can "hardwire" ourselves?

On Tue, Aug 23, 2016 at 12:21 PM, John Wieczorek notifications@github.com
wrote:

Definitely! See comment on issue #524
#524

—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub
#626 (comment), or mute
the thread
https://github.com/notifications/unsubscribe-auth/AA5hb7fURUlbn6ALwbtSwn_-X88zkNpmks5qi0gjgaJpZM4JrGj7
.

[robgur]

We've asked a lot of Javi and he's helped tremendously, but I wouldn't ask
more of him without some method of supporting his time. Right now, I don't
see that method.
-r

On Tue, Aug 23, 2016 at 4:35 PM, David Bloom notifications@github.com
wrote:

This would be great. Is this something that Javi will have time for, or is
it something we can "hardwire" ourselves?

On Tue, Aug 23, 2016 at 12:21 PM, John Wieczorek <notifications@github.com

wrote:

Definitely! See comment on issue #524
#524

—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub
#626 (comment),
or mute
the thread
<https://github.com/notifications/unsubscribe-
auth/AA5hb7fURUlbn6ALwbtSwn_-X88zkNpmks5qi0gjgaJpZM4JrGj7>

.

—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub
#626 (comment), or mute
the thread
https://github.com/notifications/unsubscribe-auth/AAcc7NaXTVDbY_DEhMOIF0UXOEhqfmPnks5qi1magaJpZM4JrGj7
.

[tucotuco]

Input from Heather Prestridge. Bumping priority to "High" as part of solution to failing stats problem. See #638.

"Is there a way I can get annual report statistics from VertNET? It would be awesome to be able to report the number of times our datasets were queried and how many records were downloaded. I can see the individual queries and downloads in the activities tab on the GitHub site, but a summarization would be awesome. Just to toss into our annual report for the department."