Return to Project-GC

Welcome to Project-GC Q&A. Ask questions and get answers from other Project-GC users.

If you get a good answer, click the checkbox on the left to select it as the best answer.

Upvote answers or questions that have helped you.

If you don't get clear answers, edit your question to make it clearer.

My Caching Friends (feature/stats idea)

+5 votes
269 views

Hello, 

I have an idea for additional overview that will fit into Profile section.

My Caching Friends (or whatever we will call it) statistics should show me the list of other geocachers sorted (DESC) by number of caches that we both found on the same day (same Found it / Attended date).

Additional filters can be applied as usual in other views.

 

Example: This statistics was created on Slovak geocaching.sk website and worked until data flow from gc.com was cut back in 2011. You can still check the outcome here: http://www.geocaching.sk/extra/kto-s-kym.php?login=Rikitan

Hope the link above works for anyone.

 

thank you, 

Rikitan

asked Sep 7, 2014 in Support and help by Rikitan (3,290 points)

1 Answer

+1 vote

Can I assume that the table at the linked page is very out of date? I got this data when running a fast test:

+--------------+------+
| profile_name | cnt  |
+--------------+------+
| Adushka      | 2704 |
| belzebot     |  191 |
| Mikme        |  175 |
| Vigi         |  163 |
| cdrw         |  159 |
| Aknel84      |  154 |
| miro_m       |  129 |
| renreja      |  123 |
| DaPoncho     |  114 |
| sv.Augustin  |  101 |
+--------------+------+
 
Does it feel reasonable? I know there is an issue if someone double logs though. Solving that made the SQL query a lot slower.
answered Sep 7, 2014 by magma1447 (Admin) (211,640 points)
Wow, superfast again .. I am sorry to distract you again from your priorities.
Yes, table on linked webpage contains old data (2011) and your result make perfect sense. I am aware of slight skews due to dubble logs, i.e. but for general overview it should be good enough. And IMHO quite interesting feature for users.
Yes, not bad at all. I will look deeper into this at a later point. I don't remember exactly, but I assume that our friend suggester does something similar.

And no worries about the interruptions. I read when I have some time. Working on some different small things this evening. But going to bed any minute now.
...