Longest without a find

CaleD · Post by **CaleD** » 16 July 10 9:13 pm

Hi all
Does anyone know how to get the GCA Queries feature to pump out a list of caches in descending order of the amount of days since the cache was last found? I'm sure I have seen this somewhere before, but I can't remember where!
Cale

Post by **caughtatwork** » 16 July 10 9:15 pm

http://geocaching.com.au/stats/graphs/a ... ys_unfound

CaleD · Post by **CaleD** » 17 July 10 5:00 am

Thanks C@W. I suspect I'm actually looking for the "Top Caches by Days Unloved", but Firefox doesn't seem to want to show the graph for me. Safari tells me that the image cannot be displayed because:

"Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to allocate 552 bytes) in /var/www/site/gca/include/gca_formatting.php on line 809"

Post by **caughtatwork** » 17 July 10 10:07 am

Ahh, out of memory.
I'll have a look at this tonight.

blossom* · Post by blossom* » 17 July 10 10:16 pm

I can open this with no problems

Post by **caughtatwork** » 17 July 10 10:30 pm

blossom* wrote:I can open this with no problems

State queries don't consume as much memory, so if you picked a state or GCA only, you're probably OK.

Post by **caughtatwork** » 17 July 10 10:30 pm

caughtatwork wrote:Ahh, out of memory.
I'll have a look at this tonight.

I've upped the memory for that chart, so it should work now.
http://geocaching.com.au/stats/graphs/a ... ys_unfound

Swampy · Post by **Swampy** » 18 July 10 2:35 pm

I'll have a guess.
There was a macro for GSAK written for just such a query. It is Days Since Last Found.
I asked for this macro and KaiTeam was kind enough to write it. Works very well but you need to have your GSAK databases up to date.

Yurt · Post by **Yurt** » 18 July 10 8:50 pm

What's with the German Whereigo cache that's 6 years old in Melbourne? Is that for real?

I note Cape Barron Geese Dormitory has a DNF (logged as a maintenance note) about three years ago but nothing much else. Who's got a boat down there?

Zytheran · Post by **Zytheran** » 19 July 10 1:11 am

caughtatwork wrote:
caughtatwork wrote:Ahh, out of memory.
I'll have a look at this tonight.
I've upped the memory for that chart, so it should work now.
http://geocaching.com.au/stats/graphs/a ... ys_unfound

This appears to be missing some caches...

noikmeister · Post by **noikmeister** » 19 July 10 7:52 am

It's really easy. From the GCA front page: Caches -> View All then filter by state if you want and then click on the Found column and it will sort with unfound caches at the top followed by the most unloved.

I have knocked off the 4 most unloved in the ACT this way @ 108, 96, 96 and 103 weeks since found respectively.

Cheers,
Jeremy.

Post by **caughtatwork** » 19 July 10 9:02 am

Zytheran wrote:
caughtatwork wrote:
caughtatwork wrote:Ahh, out of memory.
I'll have a look at this tonight.
I've upped the memory for that chart, so it should work now.
http://geocaching.com.au/stats/graphs/a ... ys_unfound
This appears to be missing some caches...

Such as?

Bundyrumandcoke · Post by **Bundyrumandcoke** » 20 July 10 12:28 am

Well Im happy with the fact that 2 of those caches on that list are mine. Im unhappy about the fact the oldest unfound Qld cache is only a couple of hours away from work, and I havent made the time to have a go at it.

Cheers
Bundy

Zytheran · Post by **Zytheran** » 29 July 10 6:45 pm

caughtatwork wrote:
Zytheran wrote: This appears to be missing some caches...
Such as?

When I filter for South Australia I noticed that some of mine that have been unfound for 3 or 4 months don't show up.
Z's C by A century of Evil (GC24V3R) Placed 9th March 2010
2-3-74 by Zytheran (GC27E2P) Placed 25th April 2010

Link I used
http://geocaching.com.au/stats/graphs/a ... ys_unfound

What am I doing wrong?

Post by **caughtatwork** » 29 July 10 8:07 pm

Nothing.
There has been a disturbance in the feed which caused the cache listing to archive.
Archived caches don't show up on that list anymore.
I've fixed the two in question and CR is having a look at the feed profiles to see if we can tweak them to avoid this problem for a while.

Geocaching Australia

Longest without a find

Longest without a find

Re: Longest without a find

Re: Longest without a find

Re: Longest without a find

Re: Longest without a find

Re: Longest without a find

Re: Longest without a find

Re: Longest without a find

Re: Longest without a find

Re: Longest without a find

Re: Longest without a find

Re: Longest without a find

Re: Longest without a find

Re: Longest without a find

Re: Longest without a find