|
Post by SSO JOAT on Jun 30, 2011 9:38:11 GMT -9
Interested in the quickest and easiest way to build a series of Pocket Queries to gather all of Alaska's cache information? Well here it is in 8 easy PQ's... Note that you can run up to 10 PQ's per day, so you can get the full set for the state in one day. You can manage this by going to your Pocket Query control panel and checking the day of the week you next want each one to run. Follow these steps to create your full state PQ set: Start Building a New PQ from your geocaching.com Premium account. Give it a name. I use AK-1, AK-2, AK-3, AK-4, AK-5, AK-6, AK-7, and AK-8 for mine out of pure simplicity. At the very bottom of the page, I also check the "Include PQ Name" box so that name tag is part of the filename, making ID of which is which so much easier. Unless you want the query to run automatically every week, pick the "Uncheck the day of the week after the query runs" radio button. When you want a PQ set, just go down the list and check the day box for each PQ you want to gather and it will run once and then wait for the next time you call for it. If you want them now, make sure you use the day shown on the "server time" label just above the PQ list. Change the "Show me... caches of" box to the maximum of 1000 caches. Scroll down to the "Within" box and select the radio button for "States/Provinces". Scroll that list down a few entries and select "Alaska". Go down to the "Placed During" box (just above the attributes pictures boxes). Select the radio button in front of the "between date range" fields. For each of the 8 separate PQ's, set the dates to match the following: AK-1 = May 02, 2000 and August 29, 2008AK-2 = August 30, 2008 and January 30, 2011AK-3 = January 31, 2011 and February 19, 2013AK-4 = February 20, 2013 and September 20, 2014AK-5 = September 21, 2014 and May 7, 2016AK-6 = May 8, 2016 and September 6, 2018AK-7 = September 7, 2018 and October 17, 2020AK-8 = October 18, 2020 and December 31, 2023You need to keep an eye on the size of the last query and as the number of caches generated approaches about 980, you would set the end date and build a new PQ for the next series (AK-9). Leave a larger buffer in the most recent PQs to allow for unpublished caches which cachers may still be editing and may show up under an older "hidden date" when they finally do get published. Do not change any other settings on the page. Except for the above, all the remaining query fields should be blank or inactive. Go to the bottom of the page and click the "Submit Information" button. Take a look at the results # at the top of the next page. It should be a little under 1000 caches (as of the latest edit, the above ranges generate 999, 999, 999, 1000, 997, 997, 999, and 787 caches). You can now check a day of the week button at the top of the page and then hit the submit button at the bottom to trigger the PQ to active. With the download of these 8 PQ's, you can import and update the entire state of Alaska into GSAK for easy searching and filtering offline. Good Luck! EDIT: Updated date ranges and cache totals as of February 17, 2023.
|
|
|
Post by SSO JOAT on Apr 23, 2012 20:40:18 GMT -9
Date ranges and cache tallies for Alaska's Pocket Query results updated in OP.
|
|
|
Post by ladybugkids on Sept 25, 2013 7:30:22 GMT -9
It now requires six pocket queries to pull every geocache in Alaska!
Update for the dates (as of August 23, 2013):
May 03, 2000 and July 31, 2007 (965)
August 1, 2007 and June 25, 2009 (984)
June 25, 2009 and September 20, 2010 (986)
September 21, 2010 and December 31, 2011 (978)
January 1, 2012 and March 25, 2013 (977)
March 26, 2013 and December 31, 2014 (711 and growing)
|
|
|
Post by NorthWes on Sept 27, 2013 10:05:42 GMT -9
This is such a handy way to set up a mega-listing of caches!
|
|
|
Post by ladybugkids on Jan 3, 2014 10:57:25 GMT -9
I tightened things up a bit since the last update and Greatland Reviewer reaping.
Update for the dates (as of January 3, 2014):
May 03, 2000 and August 31, 2007 (997)
September 1, 2007 and August 1, 2009 (993)
August 2, 2009 and October 31, 2010 (998)
November 1, 2010 and May 18, 2012 (998)
May 19, 2012 and June 10, 2013 (999)
June 11, 2013 and December 31, 2014 (620)
|
|
|
Post by SSO JOAT on Jun 10, 2014 8:49:20 GMT -9
Date ranges in the First Post of this thread have been updated to the current date ranges. It will not be very long before we are adding a 7th PQ to the mix. Number 6 is already up to 862 caches.
|
|
|
Post by SSO JOAT on Sept 4, 2014 18:42:03 GMT -9
Updated the date ranges and added PQ number 7 to the batch since we are now over 6,161 caches in Alaska!
|
|
|
Post by ladybugkids on Sept 5, 2014 6:53:52 GMT -9
Thanks, Scott. I last updated my Alaska queries in June and you just gave me a head start.
|
|
|
Post by ladybugkids on Nov 15, 2014 15:38:53 GMT -9
Project-GC will now automatically calculate the dates at project-gc.com/Tools/PQSplit?multi_region[]=Alaska&submit=Filter.
As of today the dates are: # Start date End date Days Caches 1 September/29/2000 September/30/2007 2558 990 2 October/01/2007 September/24/2009 725 990 3 September/25/2009 April/11/2011 564 990 4 April/12/2011 July/21/2012 467 990 5 July/22/2012 August/01/2013 376 989 6 August/02/2013 August/08/2014 372 982 7 August/09/2014 275
Project-GC stops at 990 caches per PQ to leave a buffer in case a cache is unarchived.
Project-GC also calculates the number of days in each date range. It's interesting to note the apparent flattening out of cache placement beginning in July 2012.
Archive rates for 2011-2014 are approximately 188, 122, 530, and 197 (through today), respectively, based on some quick GSAK filtering. The 2014 number will increase because Greatland Reviewer will be finishing the Fall caching reaping he started in September during the next couple of weeks.
|
|
|
Post by ladybugkids on Jan 25, 2015 7:48:56 GMT -9
I updated the date ranges in the first post of this thread as well as below for folks to use for their statewide pocket queries.
AK-1 = May 03, 2000 and November 15, 2007 (997)
AK-2 = November 16, 2007 and October 31, 2009 (994)
AK-3 = November 01, 2009 and May 20, 2011 (998)
AK-4 = May 21, 2011 and August 19, 2012 (997)
AK-5 = August 20, 2012 and August 31, 2013 (998)
AK-6 = September 1, 2013 and September 30, 2014 (993)
AK-7 = October 1, 2014 and December 31, 2015 (233)
Published rates for 2010-2015, respectively, are approximately 923, 853, 944, 1077, 1088, 48.
Archive rates for 2012-2015, respectively, are approximately 143, 576, 447, 48 (through today). These numbers are different than posted in November 2014 due to a log accounting error in my master GSAK database.
|
|
|
Post by ladybugkids on May 31, 2016 3:16:00 GMT -9
I updated the date ranges for folks to use for their statewide pocket queries.
AK-1 = May 03, 2000 and February 15, 2008 (996)
AK-2 = February 16, 2008 and March 31, 2010 (990)
AK-3 = April 1, 2010 and July 20, 2011 (991)
AK-4 = July 21, 2011 and October 20, 2012 (999)
AK-5 = October 21, 2012 and May 10, 2014 (996)
AK-6 = May 11, 2014 and April 10, 2015 (991)
AK-7 = April 11, 2015 and June 20, 2016 (999) Catches upcoming Events statewide.
AK-8 = June 21, 2016 and December 31, 2017 (10) All future events as of this morning.
So, with a little extra date tinkering, it is still possible to pull all Alaskan caches in seven pocket queries, but not likely beyond the first two weeks of June, pending Greatland Reviewer's ongoing cache reaping efforts.
|
|
|
Post by ftl-ak on Jun 16, 2016 11:58:19 GMT -9
Mike I will have my laptop tonight if your early could you show me how to set this up? this is amazing! I like that you can get the whole state in 7 PQ.
|
|
|
Post by SSO JOAT on Aug 13, 2016 7:37:55 GMT -9
PQ Ranges updated for August 13, 2016. Total Alaskan caches at this moment is 7,027!
|
|
|
Post by ladybugkids on Apr 1, 2018 10:42:36 GMT -9
I updated the date ranges for folks to use for their statewide pocket queries.
AK-1 = May 03, 2000 and February 15, 2008 (945)
AK-2 = February 16, 2008 and March 31, 2010 (921)
AK-3 = April 1, 2010 and July 20, 2011 (920)
AK-4 = July 21, 2011 and October 20, 2012 (913)
AK-5 = October 21, 2012 and May 10, 2014 (901)
AK-6 = May 11, 2014 and April 10, 2015 (917)
AK-7 = April 11, 2015 and June 20, 2016 (935) Catches upcoming Events statewide.
AK-8 = June 21, 2016 and December 31, 2018 (899) All future events as of this morning.
I will adjust the dates after Greatland Reviewer completes Spring cleaning, so AK-8 will last a little longer before AK-9 has to be created.
|
|
|
Post by ladybugkids on May 20, 2018 11:40:33 GMT -9
I updated the date ranges for folks to use for their statewide pocket queries.
AK-1 = May 03, 2000 and April 15, 2008 (995)
AK-2 = April 16, 2008 and May 19, 2010 (997)
AK-3 = May 20, 2010 and October 12, 2011 (997)
AK-4 = October 13, 2011 and June 19, 2013 (997)
AK-5 = June 20, 2013 and August 30, 2014 (997)
AK-6 = August 31, 2014 and October 3, 2015 (984)
AK-7 = October 4, 2015 and July 17, 2017 (996)
AK-8 = July 18, 2017 and December 31, 2018 (471) All future events as of this morning.
Total is 7434, which matches Groundspeak’s total at the moment.
|
|