| View previous topic :: View next topic |
| Author |
Message |
RubberToes Geocacher

Joined: 13 Feb 2005
Posts: 222 Location: Apple Valley
|
Posted: Wed May 09, 2007 3:42 pm Post subject: |
|
|
| 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 |
|
 |
Pear Head Past MnGCA President

Joined: 04 Apr 2004
Posts: 5594 Location: north of Duluth
|
Posted: Wed May 09, 2007 4:01 pm Post subject: |
|
|
Good point RT. I guess I'm not changing things after all. _________________ Hmm... |
|
| Back to top |
|
 |
GeoPierce Geocacher

Joined: 16 Nov 2005
Posts: 1657 Location: Eden Prairie, MN
|
Posted: Wed May 09, 2007 4:08 pm Post subject: |
|
|
| 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 |
|
 |
Paklid Past MnGCA Board

Joined: 09 May 2004
Posts: 656 Location: Eagan
|
Posted: Tue Sep 04, 2007 7:51 pm Post subject: |
|
|
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 |
|
 |
Pear Head Past MnGCA President

Joined: 04 Apr 2004
Posts: 5594 Location: north of Duluth
|
Posted: Tue Sep 04, 2007 8:01 pm Post subject: |
|
|
| 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 |
|
 |
Paklid Past MnGCA Board

Joined: 09 May 2004
Posts: 656 Location: Eagan
|
Posted: Tue Sep 04, 2007 8:03 pm Post subject: |
|
|
I do know excel very well. All the database stuff and web stuff - not so much. _________________ -Paklid |
|
| Back to top |
|
 |
Marsha and Silent Bob Past MnGCA President
Joined: 02 Sep 2003
Posts: 6261
|
Posted: Tue Sep 04, 2007 9:02 pm Post subject: |
|
|
| 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 |
|
 |
Marsha and Silent Bob Past MnGCA President
Joined: 02 Sep 2003
Posts: 6261
|
Posted: Tue Sep 04, 2007 9:25 pm Post subject: |
|
|
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 |
|
 |
Pear Head Past MnGCA President

Joined: 04 Apr 2004
Posts: 5594 Location: north of Duluth
|
Posted: Tue Sep 04, 2007 9:29 pm Post subject: |
|
|
| 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 |
|
 |
Marsha and Silent Bob Past MnGCA President
Joined: 02 Sep 2003
Posts: 6261
|
Posted: Tue Sep 04, 2007 9:31 pm Post subject: |
|
|
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 |
|
 |
Marsha and Silent Bob Past MnGCA President
Joined: 02 Sep 2003
Posts: 6261
|
Posted: Tue Sep 04, 2007 9:56 pm Post subject: |
|
|
Guess I needed to upgrade
| 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 |
|
 |
Grey Wolf and Wild Rice Geocacher

Joined: 31 May 2005
Posts: 341 Location: White Bear Township
|
Posted: Wed Sep 05, 2007 6:06 am Post subject: |
|
|
| 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 |
|
 |
Paklid Past MnGCA Board

Joined: 09 May 2004
Posts: 656 Location: Eagan
|
Posted: Wed Sep 05, 2007 6:30 am Post subject: |
|
|
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 |
|
 |
Surfer Joe Minnesota Reviewer

Joined: 18 Jan 2006
Posts: 199
|
Posted: Wed Sep 05, 2007 7:00 am Post subject: |
|
|
| 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 |
|
 |
Paklid Past MnGCA Board

Joined: 09 May 2004
Posts: 656 Location: Eagan
|
Posted: Wed Sep 05, 2007 7:37 am Post subject: |
|
|
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 |
|
 |
|