Jump to content

Pocket queries...


Recommended Posts

Thanks for the link. I am curious though, how do I use google earth to acquire this information?

Well, GE has an overlay wotsit so you can fly around the country seeing all the caches. So you can see all the caches in the UK using GE.

 

I put a winky smiley thing next to it because although it gives you a window onto all of the caches in the UK it has limitations and some people don't like it.

 

If you wanted to do some obscure stats like what difficulty 5 cache with two consecutive vowels in its name that has remained unfound for the longest, then it won't help. But if you want a quick shufty at all the caches in and around Thingytown, Wotsitshire, and then want to zoom off to South Doodah - it's ideal.

Link to comment

Well, GE has an overlay wotsit so you can fly around the country seeing all the caches. So you can see all the caches in the UK using GE.

 

If you wanted to do some obscure stats like what difficulty 5 cache with two consecutive vowels in its name that has remained unfound for the longest, then it won't help. But if you want a quick shufty at all the caches in and around Thingytown, Wotsitshire, and then want to zoom off to South Doodah - it's ideal.

GE would be even better if you could filter on cache types and owned/found caches like the geocache google map does............perhaps it does! Anyone know?

 

TLHM

Link to comment

...does anybody have an up to date list of PQ I would need to build the complete cache database?

 

Sorry if I'm being a bit dim (the last coffee is wearing off!) but why would you want a complete UK cache database? What do you do with it?

 

Holiday planning mainly but for us day trips out of our immediate area as well.

Link to comment

To get the whole UK into gsak on a weekly basis now needs two premium member accounts, as it requires over 50 PQs now.

 

This is a current workable date range setup.

 

Placed by date PQ Generation
PQ	From	To	Count	Done
01	15/12/2000	22/08/2002	491	
02	23/08/2002	02/05/2003	493	
03	03/05/2003	27/10/2003	493	
04	28/10/2003	30/03/2004	491	
05	31/03/2004	19/06/2004	484	
06	20/06/2004	22/09/2004	489	
07	23/09/2004	01/01/2005	489	
08	02/01/2005	11/03/2005	493	
09	12/03/2005	20/04/2005	495	
10	21/04/2005	29/05/2005	485	
11	30/05/2005	22/07/2005	494	
12	23/07/2005	09/09/2005	489	
13	10/09/2005	28/10/2005	492	
14	29/10/2005	26/12/2005	487	
15	27/12/2005	03/02/2006	488	
16	04/02/2006	06/03/2006	490	
17	07/03/2006	07/04/2006	478	
18	08/04/2006	28/04/2006	477	
19	29/04/2006	23/05/2006	495	
20	24/05/2006	21/06/2006	475	
21	22/06/2006	17/07/2006	488	
22	18/07/2006	13/08/2006	488	
23	14/08/2006	04/09/2006	492	
24	05/09/2006	28/09/2006	484	
25	29/09/2006	21/10/2006	475	
26	22/10/2006	17/11/2006	483	
27	18/11/2006	22/12/2006	493	
28	23/12/2006	17/01/2007	494	
29	18/01/2007	08/02/2007	483	
30	09/02/2007	27/02/2007	485	
31	28/02/2007	19/03/2007	493	
32	20/03/2007	05/04/2007	481	
33	06/04/2007	15/04/2007	483	
34	16/04/2007	27/04/2007	445	
35	28/04/2007	08/05/2007	494	
36	09/05/2007	25/05/2007	454	
37	26/05/2007	08/06/2007	468	
38	09/06/2007	21/06/2007	465	
39	22/06/2007	10/07/2007	462	
40	11/07/2007	27/07/2007	492	
41	28/07/2007	11/08/2007	448	
42	12/08/2007	25/08/2007	464	
43	26/08/2007	07/09/2007	467	
44	08/09/2007	24/09/2007	491	
45	25/09/2007	10/10/2007	460	
46	11/10/2007	26/10/2007	479	
47	27/10/2007	10/11/2007	446	
48	11/11/2007	02/12/2007	493	
49	03/12/2007	26/12/2007	480	
50	27/12/2007	09/01/2008	492	
51	10/01/2008	Maximum date	187

 

You can see 2007 saw an explosion in cache placement.

 

Hope this is of use,

Jamie.

Link to comment

GE has an overlay wotsit...

Where?

Go to My Account Details, and on the left hand side is a column with Account Options, Premium Features, and down there is "Google Mapping Features".

 

I wasn't suggesting this as a complete alternative to building your own giant offline DB, if you really want to. Just that unless you have a very specific purpose in mind, you could save yourself an awful lot of effort by using the GC.com tools and GM and GE.

Link to comment

...does anybody have an up to date list of PQ I would need to build the complete cache database?

 

Sorry if I'm being a bit dim (the last coffee is wearing off!) but why would you want a complete UK cache database? What do you do with it?

 

My job takes me all over the country, often at very short notice. My current record is Glasgow, Newquay, Cambridge in 3 days in that order! It's handy to be able to interrogate GSAK before I set off & load caches close to my work area into my Ipaq.

Link to comment

To get the whole UK into gsak on a weekly basis now needs two premium member accounts, as it requires over 50 PQs now.

 

This is a current workable date range setup.

 

Snip ..... Don't need to show whole list again. /Snip

 

You can see 2007 saw an explosion in cache placement.

 

Hope this is of use,

Jamie.

 

Thanks Jamie, just what I wanted.

 

Anybody who asked the question "Why do you want the whole database?".

 

I would like to keep an up to date list on GSAK. Once the database is complete then queries only need to check for updated and new caches over the past week.

 

With a complete updated database I can do lots of interesting (to me anyway) analysis which I can then use in planning caches, trips and other stuff.

Link to comment

I would like to keep an up to date list on GSAK. Once the database is complete then queries only need to check for updated and new caches over the past week.

 

With a complete updated database I can do lots of interesting (to me anyway) analysis which I can then use in planning caches, trips and other stuff.

 

In essence this is true but relying on 'updated / placed in the last 7 days' type PQs to keep your GSAK database current has one drawback... I believe that 'updated' refers to cache pages that have been updated by the cache owner, not those that have just had a new log entry added. If a cache has had a string of DNF logs added since it was loaded into or last updated, in your GSAK database, you won't know about it until it's too late; which can be a bit of a bummer :unsure:

Link to comment
^^^^^

When I said updated, what I should have said was updated and/or found in last 7 days. Sorry for any misunderstanding :D

 

With something over 24,000 active and temporarily disabled caches there could be an aweful lot of caches that have been found in the last seven days. With only 500 per PQ, I suspect you're still going to need a lot of PQs to keep a whole of the UK database up to date.

Link to comment

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...