wishes

[jcanyoneer]

After spending the last hour browsing different cachers hides, I had another idea for a wish list...Is there a way to query the database for a list of caches by "longest last to find"? I just noticed that my geocache The Play and The Show has not been found in almost 2 years...made me want to see what else in AZ has that similar stat.

[Corfman Clan]

After spending the last hour browsing different cachers hides, I had another idea for a wish list...Is there a way to query the database for a list of caches by "longest last to find"? I just noticed that my geocache The Play and The Show has not been found in almost 2 years...made me want to see what else in AZ has that similar stat.

I like that idea. It really goes along with the LonelyCache theme. The query really wasn't difficult to put together, though it does run a bit longer than I'd like (~10 sec). Here's the top 100 for LonelyCache wide:

Code: Select all

    Code       Name                                               State       NumFinders  LastDate    cCP  nfCP
    ---------- -------------------------------------------------- ----------- ----------- ----------- ---- -----------
  1 GCGG7W     The Devil Made Me Do It                            Colorado    0           2003-07-20  913  913
  2 GCP9A6     Sleeping With The Brine Shrimp                     Utah        4           2005-10-21  180  144
  3 GCJJZT     Pole Canyon........Almost                          Utah        6           2006-06-26  137  118
  4 GCWY3N     mona pole-8 (picnic anyone?)                       Utah        6           2006-09-02  102  88
  5 GCWJQN     GeoCadet's Missing Note                            Utah        2           2006-09-06  310  207
  6 GCZ8MB     The Last                                           Utah        0           2006-11-10  582  582
  7 GCJX6R     Italian Spring Trail                               Arizona     9           2006-11-11  90   81
  8 GCEBE8     Top of the Reef Cache                              Utah        13          2006-11-11  72   67
  9 GCG9K9     San Rafael Benchmark #4                            Utah        8           2006-11-11  115  102
 10 GCN4P9     Holy Mackerel Foo Foo Cache                        Utah        5           2006-11-18  149  124
 11 GCZFAR     Run, Man, Run!                                     Utah        2           2006-12-26  289  193
 12 GCZV9Z     The Lone Sentinel                                  Utah        1           2007-01-03  571  285
 13 GC106J1    From a Bird                                        Utah        3           2007-02-09  188  141
 14 GCVFKN     Beach Parcheesi                                    Utah        5           2007-03-11  127  106
 15 GCWQ6Z     What the.....                                      Utah        11          2007-03-14  56   51
 16 GCGX88     Orthocenter Rock                                   Utah        13          2007-03-19  69   64
 17 GCN30E     Mysteries of Éire                                  Utah        7           2007-04-05  106  93
 18 GC105J5    The Survivors ( MacGyver Cache # 70 )              Utah        1           2007-04-09  567  283
 19 GCYXCJ     End of the road as far as the Prelude goes         Utah        4           2007-04-28  147  117
 20 GCGM5D     A Madness to the Methodist                         Colorado    20          2007-04-29  45   43
 21 GCRR8H     The Mother Lode                                    Utah        5           2007-05-08  133  111
 22 GCMZ21     The Treasury                                       Utah        18          2007-05-08  41   39
 23 GCGYQ5     Don't climb to the ridgetops - Not a solution yet  Utah        11          2007-05-31  81   74
 24 GC10N8Q    The Cliffs of Baldy                                Utah        12          2007-06-02  46   43
 25 GCWVNV     Cryptology 101                                     Utah        7           2007-06-11  88   77
 26 GCGTPB     ATV OVERLOOK                                       Utah        9           2007-06-16  100  90
 27 GC130Z9    The Fifth Element                                  Colorado    5           2007-06-20  105  88
 28 GCGMFZ     Top Of The Pole                                    Utah        9           2007-06-30  100  90
 29 GCZ1KZ     Team 4                                             Colorado    3           2007-07-10  195  146
 30 GCPXWH     Lions and Eigers and Bears, oh my!                 Utah        6           2007-07-22  118  101
 31 GCQT15     Ibapah-saddle                                      Utah        7           2007-07-28  98   86
 32 GC12NC8    Return of the Multi-Puzzle Cache                   Utah        4           2007-08-04  133  106
 33 GC12NCK    Dial-A-Cache                                       Utah        6           2007-08-09  88   76
 34 GCPXRP     Little Brown Jug                                   Utah        6           2007-09-01  118  101
 35 GCJGJR     In Search of the Hermit's Lost Coins               Utah        13          2007-09-03  63   59
 36 GC15J42    Utah Geocaching History Challenge                  Utah        0           2007-09-11  498  498
 37 GCQVJ6     Dorkteam6 1500 and HOF                             Utah        10          2007-09-16  69   62
 38 GC13VMR    Golgatha                                           Colorado    5           2007-09-24  104  86
 39 GCRW8K     Deadman                                            Arizona     4           2007-10-05  166  133
 40 GCA3C0     Dry Fork Arch                                      Utah        8           2007-10-07  123  109
 41 GCT232     Tribute to Geocadet: Wandering                     Utah        5           2007-10-12  132  110
 42 GCCA42     Cox Swale                                          Utah        14          2007-10-13  68   64
 43 GCX5JK     R.B. cache                                         Utah        14          2007-10-23  43   40
 44 GC16Y4C    Utah Confluence Challenge Cache                    Utah        0           2007-10-24  486  486
 45 GC12RC5    Fexx06 Puzzle Cache                                Utah        1           2007-11-10  532  266
 46 GCZMZM     Vincents Jetski                                    Utah        7           2007-11-15  82   71
 47 GCPJT2     Long Hauler                                        Utah        8           2007-11-22  89   79
 48 GC15QXC    Major Intersection                                 Nevada      12          2007-12-16  41   38
 49 GCWQ0R     Insight                                            Nevada      8           2008-02-09  77   68
 50 GC17G14    Arizona Elbow View Parking                         Arizona     5           2008-02-23  95   79
 51 GCA218     The million dollar view   $$$                      Utah        13          2008-03-01  75   70
 52 GC9283     Coyote Crossing                                    Arizona     20          2008-03-08  49   47
 53 GCZ3PD     HANDICAPPER GENERAL                                Arizona     9           2008-03-22  64   58
 54 GC23W2V    A Ace Inflight Twist Polo Pony                     Utah        0           2008-04-20  437  437
 55 GC1B43Q    Right Fork of Red Canyon                           Utah        8           2008-04-20  55   48
 56 GCV1P9     Midnight Madness                                   Utah        11          2008-04-27  58   53
 57 GC19KYV    Tomato Juice                                       Utah        4           2008-04-30  112  90
 58 GCW67K     Mister Vaquero                                     Utah        5           2008-05-05  125  104
 59 GC1CBJV    Foo's Bearclaw Night Cache (In Your Honor)         Utah        3           2008-05-21  143  107
 60 GCRTRN     Four Farmington Falls                              Utah        14          2008-05-24  47   44
 61 GC118C4    The Evil Doctor's Revenge                          Utah        6           2008-05-26  91   78
 62 GCN6VZ     DUDETTE                                            Utah        16          2008-06-04  46   43
 63 GCXW4M     No 4x4s allowed                                    Utah        9           2008-06-08  67   60
 64 GCYV9X     Tumacacori Listening Point                         Arizona     7           2008-06-21  84   73
 65 GCKE57     hucks atv adventure                                Utah        10          2008-06-26  80   72
 66 GCT9KK     Dick's Peak                                        Arizona     8           2008-06-27  82   73
 67 GC1C8W1    Drol Tom                                           Utah        2           2008-06-29  215  143
 68 GC15MQ6    Windy Cache                                        Nevada      4           2008-06-30  124  99
 69 GC12Y55    A look at the summit                               Utah        5           2008-07-08  106  88
 70 GCGRYJ     Taylor Mt. Overlook                                Utah        8           2008-07-16  112  100
 71 GC1DE63    Juicey Juice                                       Utah        0           2008-07-19  413  413
 72 GCG9EJ     Altar Rock                                         Utah        12          2008-07-20  76   70
 73 GC14KYW    My Precious                                        Utah        12          2008-07-24  42   39
 74 GCGV6Q     Dial Out SG1                                       Utah        11          2008-07-31  81   75
 75 GCMF3Q     Slide Canyon Night Adventure                       Utah        12          2008-08-02  63   58
 76 GCJAND     Another Maple Canyon?                              Utah        16          2008-08-05  52   49
 77 GC3DFF     The Fourth Piggies Home                            Nevada      18          2008-08-10  58   55
 78 GCYGM5     The Big Narly Tree overlooking the falls           Utah        4           2008-08-13  148  118
 79 GC17EAK    Saving Silny's Gasmoney                            Arizona     4           2008-08-19  119  95
 80 GC1319B    Paiute/Fremont Indian Overlook                     Utah        7           2008-08-24  75   66
 81 GCP876     hucks atv adventure # 2                            Utah        8           2008-08-27  90   80
 82 GC15CZ4    Mark & Merrill's Red Cliff Geo Cache               Utah        3           2008-08-27  167  125
 83 GCJ902     Flat Top in San Rafael                             Utah        11          2008-09-10  76   69
 84 GC64E8     360 Views                                          Utah        17          2008-09-11  60   56
 85 GCY5V2     Temple Mountain South Peak                         Utah        19          2008-09-19  31   29
 86 GCGBCB     Mineral Point Survivor                             Colorado    25          2008-09-20  36   35
 87 GCKT4P     this is pointless                                  Utah        13          2008-09-21  60   56
 88 GCNK1H     SEVEN                                              Nevada      25          2008-09-26  29   28
 89 GCY6HP     Domino Theory: Primary Objective                   Arizona     8           2008-09-27  74   66
 90 GC1CXPQ    n0wae Tahosa can find this                         Colorado    3           2008-09-28  141  106
 91 GC16J3E    Top Brand "4X" Range                               Utah        3           2008-10-06  163  122
 92 GCG41N     Rancho de la Canada                                New Mexico  18          2008-10-11  51   49
 93 GCJC66     Yet Another Maple Canyon Cache                     Utah        19          2008-10-17  43   41
 94 GC13W5Z    East Fork Antler                                   New Mexico  12          2008-10-18  43   40
 95 GCG4KC     Lady Bug Peak                                      Arizona     28          2008-10-18  33   32
 96 GCG630     holden hills                                       Utah        7           2008-11-01  132  116
 97 GC7AEB     7 Utes Lodge                                       Colorado    28          2008-11-02  36   34
 98 GC14K76    Bare Valley Picnic                                 Utah        5           2008-11-10  102  85
 99 GC1E9BZ    D. O. A. - Davis County                            Utah        5           2008-11-11  80   67
100 GC1A7KF    Sparky's History Lesson                            Colorado    8           2008-11-12  55   49

Here's the query

Code: Select all

;WITH lfd
AS
(
SELECT 
	g.Code
	,g.Name
	,s.Name AS State
	,g.NumFinders
	,CASE
	 WHEN g.NumFinders=0
	 THEN COALESCE(g.PublishedDate,g.PlacedDate)
	 ELSE (SELECT MAX(LogDate) FROM Log WHERE Log.CacheID=g.ID)
	 END AS LastDate
	,CAST(FinderPoints AS INT) AS cCP
	,CAST(Points/(NumFinders+1) AS INT) AS nfCP
FROM Geocache g
JOIN GeocacheRegions r ON r.CacheID=g.ID
JOIN State s ON s.ID=g.State
WHERE r.RegionID=@Region
)
SELECT TOP 100 * FROM lfd
ORDER BY LastDate

[AllWright]

I think it would be great, now that the site is working well and seems robust, to add some documentation for new users. Whenever I meet other cachers, I bring up LonelyCache, but the site is a bit confusing without any info as to how points are calculated, or what constitutes a backcountry cache, etc. Those of us who were familiar with the DGP don't need it, but a new user will be a bit lost.

P.S. It's great having the site working - just adds that extra fun dimension to an already fun activity! Thanks!

[Corfman Clan]

I think it would be great, now that the site is working well and seems robust, to add some documentation for new users. Whenever I meet other cachers, I bring up LonelyCache, but the site is a bit confusing without any info as to how points are calculated, or what constitutes a backcountry cache, etc. Those of us who were familiar with the DGP don't need it, but a new user will be a bit lost.

P.S. It's great having the site working - just adds that extra fun dimension to an already fun activity! Thanks!

I agree. Work has been started on creating some sort of knowledge books. That work may have stalled. I'll have to follow up with how it's coming along.

[TheBlizzles]

Will these knowledge books include maps showing the various regions and counties?

Posted from my Droid with Tapatalk ... sorry if my response is short

[Corfman Clan]

Will these knowledge books include maps showing the various regions and counties?

Posted from my Droid with Tapatalk ... sorry if my response is short

Probably not, but one never knows. Once we have maps for the various regions and counties, they will be placed in the various region and county pages. So far, we have not looked into creating the maps.

[firennice]

The old DGP site showed the calculation for the cache. I think it helped explain to new users how the points are calculated.

Current ChallengePoints
points awarded to each cache finder
cCPs = aCPs / Number of finders
cCPs = 726 / 3
cCPs = 241.8

That one addition would answer a number of questions about the site.

Maps would be good, but looking back I wonder if regions have even been worth it. I never open those pages. I do not remember the boundaries. Just thinkin out loud here.

[Corfman Clan]

After spending the last hour browsing different cachers hides, I had another idea for a wish list...Is there a way to query the database for a list of caches by "longest last to find"? I just noticed that my geocache The Play and The Show has not been found in almost 2 years...made me want to see what else in AZ has that similar stat.

This has now been implemented. For more details, see the Release Notes.

[firennice]

Another thing I thought of..

On the main page you have the tables
"View Statistics For"

I would put that on the base of every county and state page. Then people do not have to go back to the main page to navigate to another.

[Corfman Clan]

The old DGP site showed the calculation for the cache. I think it helped explain to new users how the points are calculated.

Current ChallengePoints
points awarded to each cache finder
cCPs = aCPs / Number of finders
cCPs = 726 / 3
cCPs = 241.8

That one addition would answer a number of questions about the site.

This has now been implemented (Release Notes)

[Corfman Clan]

Another thing I thought of..

On the main page you have the tables
"View Statistics For"

I would put that on the base of every county and state page. Then people do not have to go back to the main page to navigate to another.

This has now been implemented. The View Statistics For table is now at the bottom of every region page (for LonelyCache Wide, States, Counties, and DGP regions) along with at the bottom of every Geocache page. See the release notes for more details.

Thanks firennice, for the suggestions!