View unanswered posts | View active topics It is currently 19 December 18 11:07 am



Post new topic Reply to topic  [ 2 posts ] 
My Query output used as input to the statistics generators 
Author Message
10000 or more caches found
10000 or more caches found

Joined: 05 October 10 10:20 pm
Posts: 1167
Location: Yorke Peninsula, South Australia
GCA Found: 349
GCA Hidden: 29
100 GCA Finds
Post My Query output used as input to the statistics generators
caughtatwork wrote:
Laighside Legends wrote:
Just had an idea...

Would it be possible to get stats on just the caches returned from a query? (think along the lines of setting a query in GSAK and then running FindStatGen) But this could be extended beyond just found caches. Could be used to answer questions along the lines of, of the caches in the zone x which has the most finds?, what percentage of SA's caches are micros?, In which month were the most events held?, Of the caches hidden by x and found by me what percentage are puzzles?, and so on...

Not sure if any of that is possible but it seemed like a good idea...

Great idea. Not sure how feasible it is. The stats produced at the moment can't be added to by the user. They are all coded by the developers. Adding in a MyQuery to the same stats is conceptually feasible. Adding other stats is not something I can think of as to how it can be done. You are talking about an open query engine which I wouldn't know how to implement. There's also a huge risk that a malformed query can hang the DB. At least using GSAK you only hang your own PC. Obviously you can get the data you want in the raw form by the query, you just can't use GCA to manipulate it to derive additional statistics. Maybe for the arcane queries you need to go to GSAK and import the query data from GCA and then write / run your own macros? Dunno. This is an interesting discussion.

While making your own stats would be nice there are a lot of problems like you say. But that's not what I was suggesting...

The list of things at http://geocaching.com.au/stats/graphs/ is fine (and if not than that's a different problem) but as it currently stands, you can only filter by state and GCA caches/non-GCA caches. What if you could feed the output from any query (from http://geocaching.com.au/my/query/) into the currently available stat graphs at http://geocaching.com.au/stats/graphs/?

This seems like it might require a lot of computational power but I might be wrong there...


11 January 16 4:38 pm
Profile E-mail
Online
User avatar

Joined: 17 May 04 12:11 pm
Posts: 15756
Location: Melbourne
GCA Found: 1240
GCA Hidden: 333
100 GCA Finds500 GCA Finds1000 GCA Finds
Post Re: My Query output used as input to the statistics generators
From a long time ago which never progressed.

How much is this of interest to anyone / everyone? It's a non-trivial amount of work to add the query generator output to all of the graphs and if this is required / requested by one person it's not worth pursuing. If, on the other hand, people are interested in this as an output and would use it, pipe up and we can look at the effort vs the potential return.

If you really, really want this, then encourage others to have their say. 2 people saying yes won't cut it, not will 5 or 10. We will need a lot of people to suggest this is a good use of our development resources before it can happen.


03 September 18 3:06 pm
Profile E-mail WWW
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 


Who is online

Users browsing this forum: No registered users and 27 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Forum theme by Vjacheslav Trushkin for Free Forum/DivisionCore.