Author Topic: Finding Caches by CO name  (Read 1451 times)

0 Members and 1 Guest are viewing this topic.

sasharambles

  • Guest
Finding Caches by CO name
« on: May 06, 2014, 11:24:01 »
I'm working on a challenge (http://coord.info/GC35W5J) which is based on finds by the first letter of the CO name. Is there a tool out there that lets me search for caches in this way? I actually have most of the alphabet completed (for a local series of similar caches - by buddysally), but this one is looking for #'s too. It looks like I'm going to have to widen my net for that one.

Thanks,

Sasha

BlackRose67

  • Big Time Cacher
  • *****
  • Posts: 589
Re: Finding Caches by CO name
« Reply #1 on: May 06, 2014, 12:20:50 »
I use GSAK for challenges such as that.

My Geocaching Profile (http://www.mygeocachingprofile.com) has an alphanumeric challenge tool built in.

BluePanther51

  • Baby Cacher
  • *
  • Posts: 49
Re: Finding Caches by CO name
« Reply #2 on: December 24, 2014, 14:55:36 »
My Geocaching Profile does a great job of showing what you have already found but how do you get the missing caches?

Seems Pocket Query or advanced search need the cachers name rather than a wild card.

I'm looking for caches by owners with names beginning with O* Q* and U*, 0 2 7 and 9. 

My only thought at the moment is to go over the past logs and look for the caches listed there.

BlackRose67

  • Big Time Cacher
  • *****
  • Posts: 589
Re: Finding Caches by CO name
« Reply #3 on: December 25, 2014, 01:03:22 »
I use GSAK for storing PQs, as well as my finds.

Makes it easy to find caches placed by owners whose caching name starts with a specific number or letter.

Here's what I've found from my databases

For Q, Quick6 has a couple caches in the area (all east end).

For O, you could use the First Post - Ottawa virtual by outforthehunt.

GC2ZNM1 The Quiet Road   by   007rty

GC3J4VT Osprey Observer   by    25thNepean
GC5HZ49   Tanger Three by 22Bongo
GC5HZ29   Tanger One   by 22Bongo
GC5HZ3Q   Tanger Two   by 22Bongo

GC56495   ulysses1118 by ulysses1118

kirok

  • Administrator
  • Big Time Cacher
  • *****
  • Posts: 690
  • "To boldly find what no cacher has logged before!"
    • Binthair Challenge
Re: Finding Caches by CO name
« Reply #4 on: December 29, 2014, 20:50:53 »
Not the most elegant way of coding it (could have used RegEx), but it's at least human readable in a pinch.  In a new GSAK filter window, click on the WHERE tab and paste in the following:

SUBSTR(ownername, 1, 1) >= '0'
AND
SUBSTR(ownername, 1, 1) <= '9'

You'll get all the caches in your database with the owner name that start with 0 to 9.

In you're looking for unfound caches only, just tack on AND found = 0, or use the usual filter checkboxes to refine the filter.