How do I search/filter/download based on number of log entries

[+macfreek]

Is there a way to find (or download) the number of logs for a list of nearby caches?

 

I've started geocaching last year, and by now found a large portion of nearby caches that are in cycling range from my home.

I like to find a selection of interesting caches a bit further away, but found that just filtering on favourite points did not really work for me -- most results are from caches in nearby cities, which are not really of interest to me (neither to find them there, nor to travel to that place). So I like to find caches with a high ratio of favourite points per number of log entries.

 

I was hoping to just search for all caches, copy the list (to an Excel sheet or so) and calculate these ratio's myself. However, none of the lists or downloads I can find lists this number of logs. The only place to see the number of log entries is on the individual cache page, which would require me to manually visit ~1000 cache pages.

 

Is there a way to find (or download) the number of logs for a list of nearby caches? Any format will do. So far I've tried the search page (https://www.geocaching.com/play/search), Pocket Queries (https://www.geocaching.com/pocket/), and the API (https://api.Groundspeak.com/documentation and https://apidevelopers.geocaching.com/). I suspect that the API is easiest (some programming is no issue), but "personal geocaching databases", "personal project", "or "temporary projects" seem explicitly excluded from using the API.

 

Any suggestion how to get this metric, or otherwise find interesting nearby caches?

[+IceColdUK]

Have you looked into GSAK?

[+TriciaG]

There's also a datum showing the percentage of premium members who gave the cache a favourite point. That might be a better metric (since basic members cannot give them, if a cache is found by a gazillion basic members, it'll skew your results).

However, I don't know if that data point is searchable on GC, either. GSAK is probably your best bet.

[+macfreek]

Thanks for the replies!  I never heard about GSAK. Sadly, when I found it, it seems a Windows-only application, and I'm running MacOS or Linux.

 

But thankfully to the description of this metrics, I found a related forum post, which lead to https://project-gc.com/Statistics/TopFavPct, which helped met get the desired list. Thanks!

[+2Abendsegler]

The pocket query display contains a percentage of favorite points. You can sort the list by favorite points (you cannot sort by percentage of favorite points). And then you can scroll through the list and look at those caches that have more than for example 70% favorites. This is not a 100 percentage solution, but it is easy to find potentially suitable caches.

 

This is the path I'm treading.

 

To do this, you need the GClh script, which automatically set the percentage of favorite points in the pocket query.