+G3cube Posted February 15, 2010 Posted February 15, 2010 I have found a shared bookmark list showing the oldest active caches in California by County. Several of those have since been archived. How do I go about finding the next oldest in that particular county? I can't see how to sort a pocket query by county. Quote
+WRASTRO Posted February 15, 2010 Posted February 15, 2010 I would suggest you try contacting the owner of the bookmark list since he/she knew how to do it to begin with. Quote
+pppingme Posted February 15, 2010 Posted February 15, 2010 Just playing with some quick numbers, it looks like 2 days worth of PQ's (10 pq's in all) will get you everything in CA from 9/2000 (first cache in ca) to 4/2004. Load that into GSAK, then I would think it would be pretty easy to figure it out with a simple sql query (maybe ask on the gsak forum for help with the sql statement). With that I would think it would cover almost every county, then the few that may be missing would probably be pretty easy to find by hand. I'm thinking most counties would probably have something by April 2004. Quote
hoyshnin Posted February 15, 2010 Posted February 15, 2010 I have found a shared bookmark list showing the oldest active caches in California by County. Several of those have since been archived. How do I go about finding the next oldest in that particular county? I can't see how to sort a pocket query by county. Could you provide us with a link? I'd be interested in seeing the list. Quote
+Don_J Posted March 11, 2010 Posted March 11, 2010 I have found a shared bookmark list showing the oldest active caches in California by County. Several of those have since been archived. How do I go about finding the next oldest in that particular county? I can't see how to sort a pocket query by county. Could you provide us with a link? I'd be interested in seeing the list. California Counties' Oldest Quote
jholly Posted March 11, 2010 Posted March 11, 2010 (edited) Just playing with some quick numbers, it looks like 2 days worth of PQ's (10 pq's in all) will get you everything in CA from 9/2000 (first cache in ca) to 4/2004. Load that into GSAK, then I would think it would be pretty easy to figure it out with a simple sql query (maybe ask on the gsak forum for help with the sql statement). With that I would think it would cover almost every county, then the few that may be missing would probably be pretty easy to find by hand. I'm thinking most counties would probably have something by April 2004. Don't need a sql query. It can be done from the filter GUI. Or just sort be county and date placed. Edited March 11, 2010 by jholly Quote
+G3cube Posted March 11, 2010 Author Posted March 11, 2010 I have found a shared bookmark list showing the oldest active caches in California by County. Several of those have since been archived. How do I go about finding the next oldest in that particular county? I can't see how to sort a pocket query by county. Could you provide us with a link? I'd be interested in seeing the list. Quote
+G3cube Posted March 11, 2010 Author Posted March 11, 2010 I have found a shared bookmark list showing the oldest active caches in California by County. Several of those have since been archived. How do I go about finding the next oldest in that particular county? I can't see how to sort a pocket query by county. Could you provide us with a link? I'd be interested in seeing the list. California Counties' Oldest I came across it on GC5F (Yuba City). the owner is budd-rdc. I retyped it with the name of the county in front so it would alphabetise better but I've never "shared" a bookmark list so I don't know if you can see it. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.