View previous topic :: View next topic |
Author |
Message |
Dragonfreys

Joined: 12 Feb 2006 Posts: 368 Location: Manitoba-Westman
|
Posted: Dec 02, 2006 6:47 am Post subject: Manitoba Geocaching Placement Statistics |
|
|
Hi all,
Reaching 1000 caches (a few times) raised a number of questions that no one seemed to want to tackle, like how many were placed since caching started here, what percentage have been archived, what's the ratio of cache types over time, are we being overrun with micros, etc, etc?
So I PQ'd grnbrg's archived cache list (thanks) and then tried to add all the active caches in Manitoba into GSAK. Exported it into excel via csv and ran a bunch of pivot table queries and generated the following tables which people may find interesting (I know I did).
First archived caches. Naturally the older the cache the more likely it is to be archived but I was surprised that only 20% of caches placed since caching began in MB have been archived. The table below shows by year the cache was placed the percentage of active vs archived caches. Note that we are at 1290 total placed caches. I noticed that I seem a couple of caches light on the active count (1020 rather than 1022) so there may be a few errors but it should be pretty close.

-- Edited by Dragonfreys at 00:58, 2006-12-02
|
|
Back to top |
|
 |
Dragonfreys

Joined: 12 Feb 2006 Posts: 368 Location: Manitoba-Westman
|
Posted: Dec 02, 2006 7:11 am Post subject: Cache types |
|
|
Next was the type of caches placed from the beginning

This wasn't too surprising although I didn't realise there had been that many events already. Then it was split out by year.

This is a very encouraging trend for caching in Manitoba. Looks like a log growth curve.

|
|
Back to top |
|
 |
Dragonfreys

Joined: 12 Feb 2006 Posts: 368 Location: Manitoba-Westman
|
Posted: Dec 02, 2006 7:23 am Post subject: Cache Density |
|
|
By this point I was starting to wonder about cache density so I popped the data into a GIS and ran a kernel density grid analysis on 100 m resolution for Manitoba and 50 m in Winnipeg. Winnipeg's density was so much higher than every where else I had to show the Manitoba density as a standard deviation to have any other hotspots show up (a little over 400 of the active caches in MB are within the perimeter by the way). It gives you a good idea where the hot spots of caching are in the province.

Note that the Winnipeg area analysis uses the perimeter (roughly) as a cutoff but much of the high density caching unfiltered was carried to the northeast all the way to Bird's Hill PP.

Its pretty easy to see where there is room for more caches and where the density is already pretty high. The highest density spot is the UofM with over 10 caches/sq km.
|
|
Back to top |
|
 |
Dragonfreys

Joined: 12 Feb 2006 Posts: 368 Location: Manitoba-Westman
|
Posted: Dec 02, 2006 7:34 am Post subject: Caches by Month |
|
|
Does cache placing slow down in the winter - you betcha. Do you think the May blitz had an impact? Check this out.

Last edited by Dragonfreys on Aug 16, 2008 8:59 pm; edited 2 times in total |
|
Back to top |
|
 |
Dragonfreys

Joined: 12 Feb 2006 Posts: 368 Location: Manitoba-Westman
|
Posted: Dec 02, 2006 7:41 am Post subject: Cache Size |
|
|
One of the big issues of late is the perceived proliferation of micros. Are we really being overrun with the little buggers? Perhaps not, looks like small is the cache size of choice, followed by regular and micros coming in at third.

Last edited by Dragonfreys on Aug 16, 2008 9:01 pm; edited 2 times in total |
|
Back to top |
|
 |
dani_carriere

Joined: 04 Feb 2005 Posts: 512 Location: Winnipeg
|
Posted: Dec 02, 2006 7:43 am Post subject: RE: Manitoba Geocaching Placement Statistics |
|
|
HOLY COW!!!!
Amazing! You've put a whole lot of work into this Sean! I'm extremely impressed. I'm a fan of statistics.
I would be interested in having this permanently available on our web site. Is this something you'd be willing to share there?
You're my hero!
|
|
Back to top |
|
 |
Dragonfreys

Joined: 12 Feb 2006 Posts: 368 Location: Manitoba-Westman
|
Posted: Dec 02, 2006 7:54 am Post subject: Bugs |
|
|
Another stat that was queried because it was there, was what is the probability of a given cache type containing a travel bug? Now you know.

|
|
Back to top |
|
 |
Dragonfreys

Joined: 12 Feb 2006 Posts: 368 Location: Manitoba-Westman
|
|
Back to top |
|
 |
slippery_1

Joined: 23 Apr 2006 Posts: 228 Location: Manitoba
|
Posted: Dec 02, 2006 12:22 pm Post subject: RE: Manitoba Geocaching Placement Statistics |
|
|
Now I personaly could think of several other things to do at 2 am on a Saturaday morning, 1 being night caching, 2 being under the sheetes dreaming about caching, but none the less very impressive.
I proudly point out the map where the two rivers meet in the north...quite impressive red coloring there don't ya think? HUmmmmmmmm!
Never ceases to amaze me the tallents we find caching.
|
|
Back to top |
|
 |
Kabuthunk

Joined: 19 Aug 2006 Posts: 262 Location: Winnipeg
|
Posted: Dec 02, 2006 8:03 pm Post subject: RE: Manitoba Geocaching Placement Statistics |
|
|
Quite the interesting. I may only be a newbie cacher still, but it's still quite informative. I KNEW we weren't being overrun with micros. As said elsewhere... like 90% of the micros are either Mayors or Conquistas (which tend to still indeed be fun for the most part).
Yeah, safe assumtion caches placed in winter will be less. Well... at least I'll be adding at least one in December (unless something else goes horribly wrong) :P. Possibly two, but we'll see.
But as someone else mentioned, these would be interesting to see on the main mbga page.
|
|
Back to top |
|
 |
ertyu

Joined: 25 Apr 2005 Posts: 556 Location: Winnipeg
|
Posted: Dec 02, 2006 10:40 pm Post subject: RE: Manitoba Geocaching Placement Statistics |
|
|
There is one problem though, many of the "micros" are listed as small caches.
|
|
Back to top |
|
 |
JayPeg

Joined: 02 Jun 2006 Posts: 131 Location: Winnipeg
|
Posted: Dec 02, 2006 11:14 pm Post subject: RE: Manitoba Geocaching Placement Statistics |
|
|
Very impressive work you did Dragonfreys. You mentioned pivot tables and I shuddered. Glad you knew what you were doing. The stats revealed some interesting information.
Thanks for the hard work.
|
|
Back to top |
|
 |
winnipegk5
Joined: 12 Jun 2005 Posts: 49 Location: Manitoba
|
Posted: Dec 02, 2006 11:27 pm Post subject: RE: Manitoba Geocaching Placement Statistics |
|
|
Very interesting stats. Thanks for spending all the time it must have taken to put them all together. .
|
|
Back to top |
|
 |
Kabuthunk

Joined: 19 Aug 2006 Posts: 262 Location: Winnipeg
|
Posted: Dec 03, 2006 12:46 am Post subject: RE: Manitoba Geocaching Placement Statistics |
|
|
ertyu wrote:
There is one problem though, many of the "micros" are listed as small caches.
This is true (if one goes by my definitions... that being that an altoids container is a micro). I asked on the geocaching.com board about that once, and the general consensus is that an altoids tin (regular size) was a small.
Bah... the first cache I'm putting out will be a 'small', but I could easily fit about 6-8 altoids tins INSIDE of it :P I say we lobby that Altoids tins be called micros 
|
|
Back to top |
|
 |
Dragonfreys

Joined: 12 Feb 2006 Posts: 368 Location: Manitoba-Westman
|
Posted: Dec 03, 2006 3:36 am Post subject: RE: Manitoba Geocaching Placement Statistics |
|
|
dani_carriere wrote:
I would be interested in having this permanently available on our web site. Is this something you'd be willing to share there?
Actually they are already on the MBGA website in an album here. I do this type of work for a living so it really didn't take long. Took me longer to try to get the images posted properly while working around the idosyncrocies of IE7. 
|
|
Back to top |
|
 |
|