MnGCA Home MnGCA
Minnesota Geocaching Association
 
 FAQFAQ   SearchSearch   User listUser list   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Pocket Query Question
Goto page Previous  1, 2, 3, 4  Next
 
Post new topic   Reply to topic    MnGCA Forum Index -> Tech Talk
View previous topic :: View next topic  
Author Message
RubberToes
Geocacher


Joined: 13 Feb 2005

Posts: 222

PostPosted: Wed May 09, 2007 3:42 pm    Post subject: Reply with quote

GeoPierce wrote:

It doesn't matter for me because I'm not using GSAK. I wrote a program to load my queries into a MySQL database and mark caches as archived if they haven't been updated in more than 7 days. But if the cache is unarchived in the future, it will be updated to active in the database.


Well your database is the same thing as GSAK, essentially, and it does matter.

If you mark everything that's not been updated in 7 days as archived, then you won't be searching for archived caches, so that's good. But you also won't be searching for any caches that have seen no action in the past week. This is going to limit the number of possible targets for you.
Back to top
View user's profile Send private message
Pear Head
Past MnGCA President


Joined: 04 Apr 2004

Posts: 5709

PostPosted: Wed May 09, 2007 4:01 pm    Post subject: Reply with quote

Good point RT. I guess I'm not changing things after all.
_________________
Hmm...
Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger
GeoPierce
Geocacher


Joined: 16 Nov 2005

Posts: 1657

PostPosted: Wed May 09, 2007 4:08 pm    Post subject: Reply with quote

RubberToes wrote:
Well your database is the same thing as GSAK, essentially, and it does matter.

If you mark everything that's not been updated in 7 days as archived, then you won't be searching for archived caches, so that's good. But you also won't be searching for any caches that have seen no action in the past week. This is going to limit the number of possible targets for you.

Hmm, another good point I'll have to think about. The 7 day rule worked when we were downloading all the caches each week. But regardless, I don't plan on using these pocket queries for hunting caches. I only download the whole state to generate Google maps for fun. I have other queries I use for hunting caches since I seldom cache outside the southwest metro.
_________________
Tupperware doesn't belong in the kitchen!
Back to top
View user's profile Send private message Visit poster's website
Paklid
Past MnGCA Board


Joined: 09 May 2004

Posts: 656

PostPosted: Tue Sep 04, 2007 7:51 pm    Post subject: Reply with quote

I don't understand a lot of what the techies write in here. I suspect that others are in the same boat. I have been able to make pocket queries work well for me though. For those of you newish to the game that haven't tried pocket queries (I believe you need to be a premium member with geocaching.com), it's pretty cool to have all the caches organized with something like GSAK (geocaching swiss army knife). You can get a whole bunch of caches loaded into your computer for vacations or like many of us, to keep tabs on every active cache in the state of Minnesota. Once they're in GSAK, it's real easy to filter as you desire and download whatever you want into your GPSr and PDA (for descriptions). Anyway, I now need 12 pocket queries to pull all active Minnesota caches (we have a limit of 500 for each query). I've named them Minnesota One, Minnesota Two, etc.

Here's the way I set up Minnesota One:





The dates I used for the twelve queries are shown below:




I included a plot of number of active caches versus the number of days to accumulate that many caches. It's a snapshot of this week. There have been many more caches active at one point or another over the last seven years in Minnesota, but right now we're closing in on 6000 active caches at the same time. We're also just 17 days away from the 2500th day since Alvin's Phone Line (Minnesota's first cache) got published.

If you look at the plot, you'll probably notice that it's some sort of exponential. I was about to curve fit it and see what the equation was, but then I readjusted my plastic pocket protector and retaped my glasses and decided to let it go. I'm pretty sure that my mere mentioning it will force someone out there to find the equation. What the plot shows me is that we need more Surfer Joes. I do remember Mountain Man needing to approve caches a couple times a week. Doesn't Joe average more than one approval session a DAY?
_________________
-Paklid


Last edited by Paklid on Tue Sep 04, 2007 7:57 pm; edited 1 time in total
Back to top
View user's profile Send private message
Pear Head
Past MnGCA President


Joined: 04 Apr 2004

Posts: 5709

PostPosted: Tue Sep 04, 2007 8:01 pm    Post subject: Reply with quote

Paklid wrote:
I don't understand a lot of what the techies write in here. I suspect that others are in the same boat.


Paklid wrote:
I was about to curve fit it and see what the equation was, but then I readjusted my plastic pocket protector and retaped my glasses and decided to let it go.


Hmm...
_________________
Hmm...
Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger
Paklid
Past MnGCA Board


Joined: 09 May 2004

Posts: 656

PostPosted: Tue Sep 04, 2007 8:03 pm    Post subject: Reply with quote

Pear Head wrote:
Hmm...


I do know excel very well. All the database stuff and web stuff - not so much.
_________________
-Paklid
Back to top
View user's profile Send private message
Marsha and Silent Bob
Past MnGCA President


Joined: 02 Sep 2003

Posts: 6261

PostPosted: Tue Sep 04, 2007 9:02 pm    Post subject: Reply with quote

Paklid wrote:
Doesn't Joe average more than one approval session a DAY?

Based on conversations I've had w/SJ, generally when he wakes up in the morning, a couple at lunch around noon, and again after work. When they get approved really depends if they have issues or not.
_________________
Sad state of affairs.
Back to top
View user's profile Send private message
Marsha and Silent Bob
Past MnGCA President


Joined: 02 Sep 2003

Posts: 6261

PostPosted: Tue Sep 04, 2007 9:25 pm    Post subject: Reply with quote

Well, rickrich's scripts say 8 queries but it doesn't equate out to 5900+ caches?

Code:
11/05/2000-12/05/2003 #500 caches
12/07/2003-01/03/2005 #500 caches
01/04/2005-09/03/2005 #496 caches
09/04/2005-03/09/2006 #498 caches
03/10/2006-06/15/2006 #499 caches
06/16/2006-09/03/2006 #498 caches
09/04/2006-11/18/2006 #498 caches
11/19/2006-           #228 caches

Maybe I need to upgrade...
_________________
Sad state of affairs.
Back to top
View user's profile Send private message
Pear Head
Past MnGCA President


Joined: 04 Apr 2004

Posts: 5709

PostPosted: Tue Sep 04, 2007 9:29 pm    Post subject: Reply with quote

Marsha and Silent Bob wrote:
Well, rickrich's scripts say 8 queries but it doesn't equate out to 5900+ caches?

Code:
11/05/2000-12/05/2003 #500 caches
12/07/2003-01/03/2005 #500 caches
01/04/2005-09/03/2005 #496 caches
09/04/2005-03/09/2006 #498 caches
03/10/2006-06/15/2006 #499 caches
06/16/2006-09/03/2006 #498 caches
09/04/2006-11/18/2006 #498 caches
11/19/2006-           #228 caches

Maybe I need to upgrade...


Somethings wrong there... There are multiple queries required for 11/19 -> today. Certainly way more than 228 caches....
_________________
Hmm...
Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger
Marsha and Silent Bob
Past MnGCA President


Joined: 02 Sep 2003

Posts: 6261

PostPosted: Tue Sep 04, 2007 9:31 pm    Post subject: Reply with quote

I upgraded the script geo-pqs uses (geo-newest) and I'm rerunning it. We'll see how that works out.
_________________
Sad state of affairs.
Back to top
View user's profile Send private message
Marsha and Silent Bob
Past MnGCA President


Joined: 02 Sep 2003

Posts: 6261

PostPosted: Tue Sep 04, 2007 9:56 pm    Post subject: Reply with quote

Guess I needed to upgrade Wink

Code:
'11/05/2000-11/29/2003' #499 caches
'11/30/2003-11/18/2004' #499 caches
'11/20/2004-08/17/2005' #493 caches
'08/18/2005-02/22/2006' #500 caches
'02/23/2006-05/28/2006' #493 caches
'05/29/2006-08/17/2006' #499 caches
'08/18/2006-10/21/2006' #497 caches
'10/22/2006-01/17/2007' #496 caches
'01/18/2007-04/20/2007' #498 caches
'04/21/2007-06/12/2007' #499 caches
'06/13/2007-07/30/2007' #499 caches
'07/31/2007-          ' #392 caches

Thanks to rickrich's geo-pqs/geo-newest script although it's only 5864 caches...
_________________
Sad state of affairs.
Back to top
View user's profile Send private message
Grey Wolf and Wild Rice
Geocacher


Joined: 31 May 2005

Posts: 384

PostPosted: Wed Sep 05, 2007 6:06 am    Post subject: Reply with quote

Paklid wrote:
all the caches organized with something like GSAK (geocaching swiss army knife). You can get a whole bunch of caches loaded into your computer for vacations or like many of us, to keep tabs on every active cache in the state of Minnesota. Once they're in GSAK, it's real easy to filter as you desire and download whatever you want into your GPSr and PDA (for descriptions).


How are you managing caches that become archived or disabled? If the PQ only gets the active caches, some of the caches in GSAK could have become unavailable?

Are you running a seperate PQ to pick up any caches that become archived or unavailable during the same 7 day period?
Back to top
View user's profile Send private message
Paklid
Past MnGCA Board


Joined: 09 May 2004

Posts: 656

PostPosted: Wed Sep 05, 2007 6:30 am    Post subject: Reply with quote

I just use GSAK to filter based on the date of the last GPX update. Since only active caches get pulled, the inactive and archived ones drop off the filtered list. I have to keep updating the filter date (after each new set of queries get uploaded to GSAK), but that takes a couple seconds to do.
_________________
-Paklid
Back to top
View user's profile Send private message
Surfer Joe
Minnesota Reviewer


Joined: 18 Jan 2006

Posts: 199

PostPosted: Wed Sep 05, 2007 7:00 am    Post subject: Reply with quote

Paklid wrote:
What the plot shows me is that we need more Surfer Joes.


Are your caches not getting reviewed quickly enough?
Back to top
View user's profile Send private message Visit poster's website
Paklid
Past MnGCA Board


Joined: 09 May 2004

Posts: 656

PostPosted: Wed Sep 05, 2007 7:37 am    Post subject: Reply with quote

No that's not it at all. The trend makes it look like soon Surfer Joe will be doing nothing but sitting in front of the computer processing new listings by the handful.

The only way Surfer Joe could be faster is if he used ESP and approved caches before they get submitted.
_________________
-Paklid
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    MnGCA Forum Index -> Tech Talk All times are GMT - 6 Hours
Goto page Previous  1, 2, 3, 4  Next
Page 3 of 4

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2002 phpBB Group
Geocaching Cache Icons, Copyright 2009, Groundspeak Inc. All rights reserved. Used with Permission.