Re: GC6QBCA - The 1% of a thousand finds Challenge

Hi.
I need a checker please for a new cache.
Technically, find n caches in a Country, each of the n caches must have over x logged finds. At least y of the n caches need to be in different States from the others. There is 'no' requirement otherwise for a minimum number of cache finds per State.

eg: Find 10 caches in New Zealand (Country) each of which have over 1,000 logged finds. At least 2 of the caches must be in a different State (North Island, South Island, Chatham Islands) from the others.

As at 16 August 2016, there are at least 23 caches that qualify in New Zealand. 8 in South Island, 15 in North Island, nil in Chatham Islands. This bookmark list has the caches I have identified. I qualify with 2 South Is caches and 9 North Is caches from that list.

Thanks everyone,
Cheers Kevin aka GenCuster.

Here you go: http://project-gc.com/Challenges/GC6QBCA/22246

Thank you for this.

A few issues / queries...

1. Issue: Tags show checking for 8 caches in Country, then check for 2 caches in 'unique regions' in Country. Total of 10.

This does not appear to allow for more than 2 caches in 'unique regions'.eg:
1) 5 caches in each of 2 'unique regions'.
2) 3 caches in 1 'unique region', 4 in another, 3 in another.
All of which are valid.
The criteria states "At least 2 of the caches... ". How to resolve?

2. Query: Is it possible to include a link to the finders log?

3. Query: Is it possible to output 'date logged' - as an alternate to the link to the finders log, if that isn't possible.

4. Query: Can the output be in columns? Instead of space separations.

Thanks for your time and input.
GC.

1. It's two in unique regions and 8 others anywhere in NZ. It doesn't matter for those 8 which region(s) the finds are in.

2/3. Link to the log doesn't seem to be covered by that script that I can see. I've added the date found to the output.

4. Unfortunately, the spaces is an artefact of the script rather than my tag.

Thanks.
I tested as follows:
Cacher rosmar. They showed as qualifying but only 1 cache in South Island, 9 in North Island.
Cacher fuzzynz. They qualified but own GC1B2YW. I never thought of that... After scrolling back through hundreds of pages, it looks like it was a maintenance log, recorded as a find. Oops. But should be excluded, anyway, unless it's a mega or giga event.

I'm wondering if this needs to be rethought - I saw this same generic script in use on a 100 caches per month in a year challenge. As there are only 3 regions, 2 in use, In New Zealand, could they be hard-coded? Then count finds in each, count totals. Don't stop at 10, but show all their finds of caches with >= 1,000 finds. If one regional sub-total >= 2 and grand-total >= 10 it would work. If that's possible, of course. Or even without hard-coding region name?

I'm loath to go down that track though, as there are good 'counties' defined via polygon files in New Zealand (NZ) and I'd like to create a similar challenge at that level too, so I'd prefer generic.

Could you please change output to:
"output table gccode, visitdate as 'Date found', region as 'Island', num_finds as 'Number of Finds', cache_name as 'Name'."
That should make it easier to read. (I see the column names are output as lowercase, regardless of what is keyed) As I can't (yet?) change a tag or create a script,

Thanks, GC.

Nb: sample code to illustrate what I think I need, but I don't see how to add totals.

{
"challenge": [
"With name 'Caches found in South Island.' find caches where country == 'New Zealand' and num_finds >= 1000 and owner_id <> profileId and region == 'South Island'.",
"With name 'Caches found in North Island.' find caches where country == 'New Zealand' and num_finds >= 1000 and owner_id <> profileId and region == 'North Island'.",
"Fulfilled with unique caches.",
"fulfilled with 2 groups.",
PUT CODE HERE FOR SUBTOTALS. Eg: Each Group must >= 2, total >= 10
"output groups including empty with totals."
"output table gccode, visitdate as 'Date found', region as 'Island', num_finds as 'Number of Finds', cache_name as 'Name'."
]
}



Edited 1 time(s). Last edit at 08/18/2016 10:51AM by GenCuster. (view changes)

Will this work? I've restated the requirements (which is kinda my paid job) to code it as: 2 caches in each of the two regions and 6 caches anywhere.

{
"challenge": [
"With name '2 Caches found in South Island.' find 2 caches where country == 'New Zealand' and num_finds >= 1000 and owner_id <> profileId and region == 'South Island'.",
"With name '2 Caches found in North Island.' find 2 caches where country == 'New Zealand' and num_finds >= 1000 and owner_id <> profileId and region == 'North Island'.",
"With name '6 Caches found anywhere in NZ.' find 6 caches where country == 'New Zealand' and num_finds >= 1000 and owner_id <> profileId.",
"Fulfilled with unique caches.",
"fulfilled with 3 groups.",
"output groups including empty with totals."
"output sorted by visitdate table gccode, visitdate as 'Date found', region as 'Island', num_finds as 'Number of Finds', cache_name as 'Name'."  ]
}

I don't know if the 'output groups' statement will work as well as the 'output table' statement. If it doesn't, keep the 'output table' statement only. The rest of it should work, based on the limited tags* of this generic script I've seen.

* Ref: checkers for GC4DFN1, GC4HE45.

Many thanks :)

The config will not work with owner_id <> profileId because this is not a valid statement.

The only config which will work is
{
"challenge": [
"With name '2 Caches found in South Island.' find 2 caches where country == 'New Zealand' and num_finds >= '1000' and region == 'South Island'.",
"With name '2 Caches found in North Island.' find 2 caches where country == 'New Zealand' and num_finds >= '1000' and region == 'North Island'.",
"With name '6 Caches found anywhere in NZ.' find 6 caches where country == 'New Zealand' and num_finds >= '1000'.",
"Fulfilled with unique caches.",
"fulfilled with 3 groups.",
"output groups including empty with totals.",
"output sorted by region table gccode, visitdate as 'Date found', region as 'Island', num_finds as 'Number of Finds', cache_name as 'Name'." ]
}

The output will look like this
[GenCuster](https://www.geocaching.com/profile/?u=GenCuster) has used [Project-GC](http://project-gc.com/Challenges//22261 "Project-GC Challenge Checker") to see if he/she qualified for this challenge and he/she did.

2 Caches found in South Island.: 2
2 Caches found in North Island.: 11
6 Caches found anywhere in NZ.: 13
gccode date found island number of finds name
GC1JRNV 2010-12-08 North Island 1463 Inner City Wetlands (Wellington)
GCVFNW 2012-11-04 North Island 1368 Seven Steps to Heaven (Wellington)
GC2A5NA 2014-10-31 North Island 1176 The Transit Lounge (Auckland)
GC1PBR8 2014-10-29 North Island 1082 Progressive Geometry (Wellington)
GCEE0 2006-06-11 North Island 1284 Mount Victoria (Wellington, Wellington)
GCQRB8 2006-02-05 North Island 1288 Kuirau Thermal TB Hotel (Bay of Plenty)
GCVVND 2006-05-06 North Island 1148 Stationary (Wellington)
GCRWHZ 2006-02-05 North Island 1280 Kuirau Lake (Bay of Plenty)
GCMG8Q 2012-10-21 South Island 1192 The Octagon (Otago)
GC2T8A6 2013-01-12 South Island 1138 Wanaka For Sure (Otago)

Cheers.

The help is appreciated, if I could do it myself, I would...

1. So there is a way of ignoring 'owned' caches? No problems, if not.

2. If we add in a 4th group, to identify the other qualifying caches (3 in my case), will the
"fulfilled with 3 groups.",
statement only pick up the first 3 groups?
The 4th group statement would be:
"With name 'Other Qualifying Caches.' find caches where country == 'New Zealand' and num_finds >= 1000.",
The purpose of this is to output all qualifying cache finds, not just the required 10.

2a. The output statement below should be discarded, if the 4th group addition works as expected.
"output groups including empty with totals."
I'd looked at some of your tags for this checker, some output columns such as gccode, date found, name etc but I suspect that that only works when there is one cache per group?

I've also used my allocation of 10 tests today, so will have to wait a while to test with my 'known' cachers (it's 1:30am anyway), but if the tag could be updated, it would be awesome. GC.

Edit: Sorry, but could you change the sort to 'name' please? That will then match the associated bookmark list (ref in my 1st post). Thanks.



Edited 1 time(s). Last edit at 08/18/2016 03:47PM by GenCuster. (view changes)

It's impossible to make a fourth statement with no limit. The script only works with a set number of caches.

"maxInGroup": 50

Would that do? Defaults to 1,000 in that checker. Could set it to 50. If we get that many, I'd probably archive the cache and make a new challenge... GC.

Edit: Or...
The 4th group statement would be:
"With name 'Other Qualifying Caches.' find 50 caches where country == 'New Zealand' and num_finds >= 1000.",

As long as only the 1st 3 groups are used to validate the required 10 finds. The 4th group is merely to ensure all qualifying finds are listed.

If neither options work, I'm happy, as it's a 'nice to have'.

The sort by name will be really helpful though. :)



Edited 1 time(s). Last edit at 08/18/2016 03:59PM by GenCuster. (view changes)

That would not work because the checker only gives an output on the fulfilled groups.

The only way to get a full printout is to remove the statement "fullfiffed with unique caches" but the disadvantage is that the checker gives a double printout

Like this
2 Caches found in South Island.: 2
2 Caches found in North Island.: 11
6 Caches found anywhere in NZ.: 13
gccode date found island number of finds name
GC23PHX 2010-02-13 North Island 1044 Arawa Soldiers' Memorial (Bay of Plenty)
GC23PHX 2010-02-13 North Island 1044 Arawa Soldiers' Memorial (Bay of Plenty)
GC1PBR8 2014-10-29 North Island 1082 Progressive Geometry (Wellington)
GC1PBR8 2014-10-29 North Island 1082 Progressive Geometry (Wellington)
GC2T8A6 2013-01-12 South Island 1138 Wanaka For Sure (Otago)
GC2T8A6 2013-01-12 South Island 1138 Wanaka For Sure (Otago)
GCVVND 2006-05-06 North Island 1148 Stationary (Wellington)
GC1GFCM 2008-12-11 North Island 1148 Wellington 360 (Wellington)
GC1GFCM 2008-12-11 North Island 1148 Wellington 360 (Wellington)
GCVVND 2006-05-06 North Island 1148 Stationary (Wellington)
GC2A5NA 2014-10-31 North Island 1176 The Transit Lounge (Auckland)
GC2A5NA 2014-10-31 North Island 1176 The Transit Lounge (Auckland)
GCMG8Q 2012-10-21 South Island 1192 The Octagon (Otago)
GCMG8Q 2012-10-21 South Island 1192 The Octagon (Otago)
GC1KENQ 2009-08-20 North Island 1269 Paddy the Wanderer (Wellington)
GC1KENQ 2009-08-20 North Island 1269 Paddy the Wanderer (Wellington)
GCRWHZ 2006-02-05 North Island 1280 Kuirau Lake (Bay of Plenty)
GCRWHZ 2006-02-05 North Island 1280 Kuirau Lake (Bay of Plenty)
GCEE0 2006-06-11 North Island 1284 Mount Victoria (Wellington, Wellington)
GCEE0 2006-06-11 North Island 1284 Mount Victoria (Wellington, Wellington)
GCQRB8 2006-02-05 North Island 1288 Kuirau Thermal TB Hotel (Bay of Plenty)
GCQRB8 2006-02-05 North Island 1288 Kuirau Thermal TB Hotel (Bay of Plenty)
GCVFNW 2012-11-04 North Island 1368 Seven Steps to Heaven (Wellington)
GCVFNW 2012-11-04 North Island 1368 Seven Steps to Heaven (Wellington)
GC1JRNV 2010-12-08 North Island 1463 Inner City Wetlands (Wellington)
GC1JRNV 2010-12-08 North Island 1463 Inner City Wetlands (Wellington)

To get the same result with a better printout I would suggest

A config like this:
{
"challenge": [
"With name '2 Caches found in South Island.' find 2 caches where country == 'New Zealand' and num_finds >= '1000' and region == 'South Island'.",
"With name '8 Caches found in North Island.' find 8 caches where country == 'New Zealand' and num_finds >= '1000' and region == 'North Island'.",
"fulfilled with 2 groups.",
"output groups including empty with totals.",
"output sorted by num_finds table gccode, visitdate as 'Date found', region as 'Island', num_finds as 'Number of Finds', cache_name as 'Name'."
]
}

With the following print out
2 Caches found in South Island.: 2
8 Caches found in North Island.: 11
gccode date found island number of finds name
GCQRB8 2006-02-05 North Island 1288 Kuirau Thermal TB Hotel (Bay of Plenty)
GC1KENQ 2009-08-20 North Island 1269 Paddy the Wanderer (Wellington)
GC1PBR8 2014-10-29 North Island 1082 Progressive Geometry (Wellington)
GC23PHX 2010-02-13 North Island 1044 Arawa Soldiers' Memorial (Bay of Plenty)
GC1GFCM 2008-12-11 North Island 1148 Wellington 360 (Wellington)
GC2A5NA 2014-10-31 North Island 1176 The Transit Lounge (Auckland)
GCRWHZ 2006-02-05 North Island 1280 Kuirau Lake (Bay of Plenty)
GC1JRNV 2010-12-08 North Island 1463 Inner City Wetlands (Wellington)
GCVFNW 2012-11-04 North Island 1368 Seven Steps to Heaven (Wellington)
GCVVND 2006-05-06 North Island 1148 Stationary (Wellington)
GCEE0 2006-06-11 North Island 1284 Mount Victoria (Wellington, Wellington)
GCMG8Q 2012-10-21 South Island 1192 The Octagon (Otago)
GC2T8A6 2013-01-12 South Island 1138 Wanaka For Sure (Otago)

Thanks, but that reintroduces the issue of the original tag - a cacher is just as likely to find 8 qualifying caches in the South Island and only 2 in the North Island, depending on where they live, so they would fail the test.

After your input and testing, I've minimised the tag as follows. It will only output 10 results, sorted by cache name. 2 caches 'must' be found in each of the regions. Another 6 must be found anywhere in the country.

{
"challenge": [
"With name 'South Island' find 2 caches where country == 'New Zealand' and num_finds >= 1000 and region == 'South Island'.",
"With name 'North Island' find 2 caches where country == 'New Zealand' and num_finds >= 1000 and region == 'North Island'.",
"With name 'New Zealand' find 6 caches where country == 'New Zealand' and num_finds >= 1000.",
"Fulfilled with unique caches.",
"fulfilled with 3 groups.",
"output sorted by cache_name table gccode, num_finds as 'Finds', visitdate as 'Date Found', region, cache_name as 'Name'."
]
}

Would you please replace the tag with the above code?

Could you add this tag comment also?
Find 10 caches in New Zealand with over 1,000 finds. At least 2 caches must be in each region.

Many thanks. :) The cache is approved and just awaiting this to publish. GC.

Okay, I've updated the tag as requested. I've tweaked the comment slightly to:
Find 10 caches in New Zealand with over 1,000 finds. At least 2 caches must be on each main island.
(just because it doesn't require 2 caches in the Chatham Islands region)

Do you want the "output groups including empty with totals." bit in there to get counts per island?

Awesome.

No, re totals. They're unnecessary to display and could be confusing. The caches as listed are great.

Thanks - to both of you - for your time :)

Resolved... Cheers, GC.

Cool. In that case, I'll file this thread.