+Cubby&BigBear Posted April 17, 2013 Share Posted April 17, 2013 Hiw do i run a query for every cache in a province? Or state? Are queries limited to 999 caches? Quote Link to comment
+SwineFlew Posted April 17, 2013 Share Posted April 17, 2013 (edited) With a date method. When I did it for Oregon a few years back, it was a trail and error way to find the "sweet spot" of all the dates to fall within 999 limit. There is now a website with a PQ Splitter tool. Here its for Prince Edward Island, Canada. (its not perfect but will give you a good start. =Prince+Edward+Island&submit=Filter&submitbutton=Filter"]link Edited April 17, 2013 by SwineFlew Quote Link to comment
+Cubby&BigBear Posted April 17, 2013 Author Share Posted April 17, 2013 Hrmmm not sure i follow at all. I want EVERY cache in a particular province regardless of date published. Quote Link to comment
+SwineFlew Posted April 17, 2013 Share Posted April 17, 2013 (edited) Hrmmm not sure i follow at all. I want EVERY cache in a particular province regardless of date published. You will get every caches base on the date of placement It will take 7 PQ for you. For me its 33 PQ. Thats 7 days to do it. (make you click on which Country and Province you want) The reason you need to use the date is to narrow down to the 999 limit. I gave you a link to help you. Not sure if you saw it. Its not perfect but its a start. I always start around Jan 1990 and go from there. (there are a few caches out there that are placed with a fake placement date) # Start date End date Days Caches 1 2001-08-28 2010-03-27 3134 977 2 2010-03-28 2011-01-29 308 926 3 2011-01-30 2011-06-26 148 811 4 2011-06-27 2011-12-25 182 979 5 2011-12-26 2012-06-23 181 955 6 2012-06-24 2012-12-07 167 988 7 2012-12-08 637 Edited April 17, 2013 by SwineFlew Quote Link to comment
+palmetto Posted April 17, 2013 Share Posted April 17, 2013 Same answer, slightly different language. Assuming you want all the caches in Prince Edward Island, you need an efficient way to grab ~6400 caches. Each query is limited to 1000 caches, so you need to design 7 queries to grab all the PEI caches. Big circles is what most people try, center point + radius, and this is NOT efficient, lots of overlap. The efficient way to get all the cache in PEI is to ask caches by placed date, one of the options when running pocket queries, using date ranges that will yield close to 1000 caches. First I look at all the PEI caches, > http://www.geocaching.com/seek/nearest.aspx?state_id=70&ex=0&cFilter=9a79e6ce-3344-409c-bbe9-496530baf758&children=n Note they're stacked by placed date. Click the >> thingy to go to the end, the oldest cache is GC1A17 | Prince Edward Island, Canada 08/28/2001 and it's on page 317. So where is the 1000th cache? at 20 per page, it's on page 267. So page to there, and now you know the date range that will yield the oldest 1000 caches for a pocket query: 03/31/2010 - 08/28/2001 Repeat until you're current from page 276 backwards. 50 pages = 1000 caches. this will let you find a correct date range that yields 1000 caches rather quickly. 7 queries, 100% of the PEI caches. If you don't query for your owned, or those you've found, you might get this in 6 queries. Quote Link to comment
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.