+Rhino and Hedgehog Posted January 5, 2010 Share Posted January 5, 2010 Oh Guru's of the caches What are the 10 most least most visited caches in SA? and for a bonus 10 What are the 10 most visited caches in SA Link to comment
+DamhuisClan Posted January 5, 2010 Share Posted January 5, 2010 Containers in South Africa by size: Small: 1527 Micro: 1038 Regular: 964 Not chosen: 133 Other: 100 Large: 38 Virtual: 8 Link to comment
+DamhuisClan Posted January 5, 2010 Share Posted January 5, 2010 Oh Guru's of the caches What are the 10 most least most visited caches in SA? and for a bonus 10 What are the 10 most visited caches in SA This one is difficult to answer, as a new cache might have only 2 finds being 2 days old. Another cache might have existed for 4 years with only two finds. So somehow one would need to add a "time" component into the equation. Link to comment
+DamhuisClan Posted January 5, 2010 Share Posted January 5, 2010 Ok made a query with all caches placed before 2009. Surprise ... surprise, there are lots with only one find: Name Code PlacedDate count(logs.lType) Name Code PlacedDate count(logs.lType) Cathedral Peak GC15TNW 2007-09-08 1 Alice's Head GC171H3 2007-10-28 1 Ivory Trail - Camp Ntomeni GC1902T 2008-01-26 1 The TB Suicide Bridge GC1ANH5 2008-03-29 1 Jamaka stronghold view GC1AR5E 2008-03-30 1 Dam wall view GC1BTAW 2008-05-01 1 Waterberg Dassie Hotel GC1CWMT 2008-06-01 1 Outeniqua Hike - George Peak GC1DW9D 2008-07-01 1 Outeniqua Hike - Cradock Peak GC1DW9G 2008-07-01 1 FaanMeintjies GC1FTBG 2008-08-31 1 Lagoon View GC1GA7A 2008-09-04 1 Jacaranda Ship Wreck GC1GB4E 2008-09-05 1 Takazi Waterfall GC1GB7M 2008-09-05 1 Work Series III, aka Oppikoppi GC1GPN2 2008-09-28 1 Mbanyane Falls GC1GW2G 2008-10-01 1 Getowerdekop GCJN7F 2003-12-21 1 On Top of Old Smokey GCRMBZ 2005-12-13 1 Gladdebank GCWM4J 2006-06-11 1 Blouberg Views GCWYBB 2006-07-02 1 Point of No Return GCY3RE 2006-09-02 1 Then there are lots of '2's: Name Code PlacedDate count(logs.lType) Filander se cache GC1492E 2007-05-08 2 Cathedral Peak 2nd Prize GC15WEB 2007-09-08 2 A Scuba Miracle GC16727 2007-09-24 2 Cave man GC186E6 2007-12-28 2 Transkei Special GC199YE 2008-02-11 2 Black Holes GC199Z5 2008-01-31 2 Italian Cross GC19NG3 2008-02-24 2 Coram Deo GC1A25N 2008-03-09 2 Tafelberg Plateau GC1AA5C 2008-03-15 2 Toxic Tunnel GC1BF4T 2008-04-21 2 Guts Gorge GC1BWCM 2008-05-03 2 Kubusie Valley GC1C10Y 2008-05-07 2 Upper Kei GC1C24G 2008-05-08 2 Sunland ‘Big Baobab’ GC1DEHM 2008-06-22 2 Keiskamma Topo GC1DGW7 2008-06-18 2 Outeniqua Mountain Cross GC1DW98 2008-07-01 2 Tower of Babble GC1EQ3Q 2008-07-30 2 CACHE ME IF YOU CAN GC1FAMQ 2008-08-17 2 Collywobbles GC1GA6D 2008-09-11 2 Mbashe Hydro Electric Works GC1GA6Z 2008-09-11 2 Fraser Falls GC1GW3K 2008-10-02 2 No Go Landy GC1HXAW 2008-11-03 2 Dingaan's Grave GC1J7CF 2008-11-15 2 Jozini Tiger #1 GC1J7MV 2008-11-08 2 Rocky Fo-by-Fo GC1J7Q6 2008-11-15 2 Twin Falls GC1K3VJ 2008-12-25 2 Deserted Church GC1K5A2 2008-12-23 2 :-) GC1KC5K 2008-12-31 2 Lavender Blue GC1KC5P 2008-12-31 2 Just Climb It GCF9FC 2003-04-13 2 Creepy Cracks GCWZNY 2006-06-28 2 Majubasnek GCYMH6 2006-09-20 2 SQL Query: Select Caches.Name, Caches.Code, Caches.PlacedDate, count(logs.lType) from Caches Inner Join logs On Caches.Code = Logs.lParent where lType = "Found it" and Caches.PlacedDate < "2009-01-01" and Caches.Archived = "F" group by Caches.Code order by count(logs.lType); Link to comment
+DamhuisClan Posted January 5, 2010 Share Posted January 5, 2010 Top few caches with the most finds, placed before 2009: Table Top Trove GCMYYZ 2005-02-28 291 Signal Hill GC9CC4 2002-10-17 242 Cape Town TB Hotel GC114RH 2007-02-25 225 Smuts House, Irene GC3055 2002-01-05 216 TF16 180° Sea GCWK3K 2006-06-11 209 Cape Agulhas GC77E 2001-04-21 165 Kloofnek Historical 12P GCGA0Z 2003-06-17 148 Remarkable Trees: Trees To Treasure GC11M7Q 2007-03-23 144 "by any other name" (Western Cape) GCQAZV 2005-08-28 143 Top Billing Cache GCR1E6 2005-10-19 140 SQL Query: Select Caches.Name, Caches.Code, Caches.PlacedDate, count(logs.lType) from Caches Inner Join logs On Caches.Code = Logs.lParent where lType = "Found it" and Caches.PlacedDate < "2009-01-01" and Caches.Archived = "F" group by Caches.Code order by count(logs.lType) DESC Limit 10; Link to comment
+Danie Viljoen Posted January 6, 2010 Share Posted January 6, 2010 What are the 10 most least most visited caches in SA? and for a bonus 10 What are the 10 most visited caches in SA See my posting of 4 January for the 10 most found caches in South Africa. What do you mean with the most least most visited caches? There are currently 27 caches with no finds, of which the oldest ones are: 1. Twins Peak 2007-04-29 2. MITRE 2007-04-29 3. Radical pools 2007-12-10 4. Towercache 2007-12-20 5. Boegoeberg Rocks 2008-03-22 6. Springbokpan 2009-06-03 7. Venda View 2009-07-04 8. Nkandla View 2009-07-05 9. Stonehenge Karoo 2009-09-03 10. Gideon Scheepers 2009-10-30 (Orange River - Terraces is older than all of these and has no logs, but I have been informed that it has been found.) Link to comment
+Nadia & Co. Posted January 8, 2010 Share Posted January 8, 2010 quickly visited the 10 caches you listed Danie, no wonder most of them have not been found... you need to make a holiday out of finding them! Link to comment
+CapeDoc Posted January 8, 2010 Share Posted January 8, 2010 1. Twins Peak 2007-04-29 A micro!!!!!! That could be a somewhat unamusing DNF! Link to comment
+Henzz Posted January 10, 2010 Share Posted January 10, 2010 A question for the Statistic-Masters... I just saw that Waynes World went from 0 to 100 in 28 days... How bout a top 10 list of the cachers with the fastest pull away ?? Link to comment
+Carbon Hunter Posted January 11, 2010 Author Share Posted January 11, 2010 Is there any way to determine the number of underwater (scuba) caches in SA? Link to comment
+Nadia & Co. Posted January 11, 2010 Share Posted January 11, 2010 What is the oldest (active or archived) cache in South Africa? Link to comment
+Danie Viljoen Posted January 11, 2010 Share Posted January 11, 2010 What is the oldest (active or archived) cache in South Africa? The first cache in South Africa was GC163 - GCZA01, placed on 14 January 2001. It was found only once (by Jors) and was archived soon afterwards. The oldest surviving cache is GC185 - Sentinel View, placed on 18 January 2001. Link to comment
+Carbon Hunter Posted January 11, 2010 Author Share Posted January 11, 2010 Is it not feasable to "resurrect" these old caches? Or is that contrary to the spirit or guideliens of GC.com? Link to comment
+Danie Viljoen Posted January 11, 2010 Share Posted January 11, 2010 Is it not feasable to "resurrect" these old caches? Or is that contrary to the spirit or guideliens of GC.com? As far as I know Jors wanted to resurrect GCZA01, but there was a problem getting permission. He then planted GCZA01.2 about 50m away, which was as close as he could get to the original cache location. Link to comment
+Danie Viljoen Posted January 11, 2010 Share Posted January 11, 2010 Is there any way to determine the number of underwater (scuba) caches in SA? I know of no way to search for an attribute like this. Link to comment
+Nadia & Co. Posted January 11, 2010 Share Posted January 11, 2010 Is it not feasable to "resurrect" these old caches? Or is that contrary to the spirit or guideliens of GC.com? As far as I know Jors wanted to resurrect GCZA01, but there was a problem getting permission. He then planted GCZA01.2 about 50m away, which was as close as he could get to the original cache location. Hello Danie... do you by any chance know what is the oldest cache in Gauteng? Thank you for the other information!! Link to comment
+Louise_Gerhard Posted January 11, 2010 Share Posted January 11, 2010 If I remember correctly the oldest live one in Gauteng is Pretoria East 001 (GC13FB) planted on 29 Jul 2001. Gerhard Link to comment
+Danie Viljoen Posted January 11, 2010 Share Posted January 11, 2010 The first cache in Gauteng was GCE6D - Gold 1 (Jhb - Sterkfontein Area), planted on 30 June 2001, and archived in 2006. The oldest active cache in Gauteng is indeed Pretoria-East 001: Link to comment
+malo mystery Posted January 11, 2010 Share Posted January 11, 2010 To see all caches in you province in date order go to your "my profile" page and down the right hand side click on "advanced search", search by "state/country", fill in the country and then province and all the caches will be shown in date order from newest to oldest. Hit >> to get to the last page and you will see the oldest active caches. Link to comment
+Nadia & Co. Posted January 11, 2010 Share Posted January 11, 2010 To see all caches in you province in date order go to your "my profile" page and down the right hand side click on "advanced search", search by "state/country", fill in the country and then province and all the caches will be shown in date order from newest to oldest. Hit >> to get to the last page and you will see the oldest active caches. Thank you Malo!! Link to comment
+DamhuisClan Posted January 12, 2010 Share Posted January 12, 2010 I see there is a new GSAK macro which generates Badges for you. More details here: http://gsak.net/board/index.php?showtopic=13541 Link to comment
+DamhuisClan Posted January 12, 2010 Share Posted January 12, 2010 (edited) For a list of currently supported badges see this page: http://geo.stod.cz/odznaky3.htm A few more badges to aim for now. Edited January 12, 2010 by DamhuisClan Link to comment
+Nadia & Co. Posted January 14, 2010 Share Posted January 14, 2010 A question for the Statistic-Masters... I just saw that Waynes World went from 0 to 100 in 28 days... How bout a top 10 list of the cachers with the fastest pull away ?? Henzz - I think this is a very interesting question? I do not know how to determine this! Link to comment
+Jors Posted January 14, 2010 Share Posted January 14, 2010 I just saw that Waynes World went from 0 to 100 in 28 days... How bout a top 10 list of the cachers with the fastest pull away ?? I can guess who had the slowest pull away though... Link to comment
+Happy Hunters SA Posted January 14, 2010 Share Posted January 14, 2010 I just saw that Waynes World went from 0 to 100 in 28 days... How bout a top 10 list of the cachers with the fastest pull away ?? I can guess who had the slowest pull away though... I think it was more a "idle" Anton Link to comment
+Nadia & Co. Posted January 15, 2010 Share Posted January 15, 2010 What was the most caches that was found on one day in SA? I saw on an American review that the most in the world is 431 caches on one day! Link to comment
+Danie Viljoen Posted January 15, 2010 Share Posted January 15, 2010 What was the most caches that was found on one day in SA? I saw on an American review that the most in the world is 431 caches on one day! The most South African caches logged by a cacher on one day: 1. Urban Hunters: 50 on 14 Jun 09 2. Discombob: 48 on 31 Oct 06 3. GlobalRat: 44 on 27 Jul 07 4. warthog: 42 on 27 Jul 07 5. GlobalRat: 40 on 24 Mar 08 This is not to say that all of them have found all of the caches on one day - I remember that when this question was last asked somebody replied that he logged his whole vacation on one day. Link to comment
+Danie Viljoen Posted January 22, 2010 Share Posted January 22, 2010 (edited) The 4000th person to find a cache in South Africa did so on 3 January 2010. Up to 20 January, 4056 cachers have found at least one South African cache, and 4375 have written at least one log. The average number of finds per cacher is 30.9, and the average number of logs per cacher is 37.9. If one defines an active cacher as a person who has found at least 12 caches in the last year (1 per month), then there are currently 625 active cachers in South Africa. Edited January 22, 2010 by Danie Viljoen Link to comment
+Danie Viljoen Posted January 22, 2010 Share Posted January 22, 2010 Is there any way to determine the number of underwater (scuba) caches in SA? PQs now have the option to search on cache attributes. There are 3 scuba caches in South Africa: D®ive the Bus, A Scuba Miracle and Bass Lake. There are a further 13 that require swimming. Link to comment
+Team Ginger Posted January 22, 2010 Share Posted January 22, 2010 Is there any way to determine the number of underwater (scuba) caches in SA? PQs now have the option to search on cache attributes. There are 3 scuba caches in South Africa: D®ive the Bus, A Scuba Miracle and Bass Lake. There are a further 13 that require swimming. ..of which 'A Scuba Miracle' is the only actually 'hidden under water' cache.. ...and for 'D®ive the Bus' one has to do a wreck dive to gather clues to the final coordinates of the cache. Both these need some simple maintenance, although they are still there according to latest non-geo info. Owners to visit dive locatin in Feb/March. Link to comment
+Danie Viljoen Posted February 11, 2010 Share Posted February 11, 2010 There have been 42633 cache finds in South Africa in the past year, for an average of 10.8 finds/active cache. There have been 12329 cache finds in Gauteng in the past year, for an average of 15.5 finds/active cache. There have been 12939 cache finds in the Western Cape in the past year, for an average of 13.8 finds/active cache. If one looks at specific metropolitan areas: Cape Town: 8683 finds, or 18.1 finds/active cache Johannesburg: 4261 finds, or 14.9 finds/active cache Pretoria: 4804 finds, or 19.9 finds/active cache The total number of active caches in South Africa grew from 3245 to 3948 (an increase of 703). Gauteng seems to have stagnated, or maybe it is saturated, because the number of active caches has only grown by 53 during the past year. It has actually decreased over the last 5 months! Link to comment
+Danie Viljoen Posted February 11, 2010 Share Posted February 11, 2010 The 10 most popular caches in South Africa over the past year have been: GC114RH Cape Town TB Hotel 103 finds GCMYYZ Table Top Trove 80 finds GCWK3K TF16 180° Sea 77 finds GC9CC4 Signal Hill 74 finds GC1PVK6 Hurling Swaai 74 finds GC1N9AM Table Mountain 73 finds GC1MY75 Jannie's Veggie Patch 65 finds GC16GBB Ireland in South Africa 64 finds GC1N8C0 Willis Walk - Like A Penguin? 64 finds GC1MHD4 Memories from a Republic 63 finds All of them are in Cape Town! Link to comment
+Danie Viljoen Posted February 11, 2010 Share Posted February 11, 2010 Distribution of caches i.t.o. District Municipalities The number of caches in each of the 52 District and Metropolitan municipalities of South Africa: Cape Town (Western Cape) 481 eThekwini (KZN) 306 Ehlanzeni (Mpumalanga) 294 Johannesburg (Gauteng) 286 Tshwane (Gauteng) 242 Amatole (Eastern Cape) 188 Boland (Western Cape) 136 Overberg (Western Cape) 122 Cacadu (Eastern Cape) 121 Bojanala (North West) 119 Eden (Western Cape) 96 Uthukela (KZN) 93 Nelson Mandela (Eastern Cape) 92 Mopani (Limpopo) 89 Umgungundlovu (KZN) 88 Weskus (Western Cape) 88 Motheo (Free State) 74 West Rand (Gauteng) 70 Sedibeng (Gauteng) 66 Nkangala (Mpumalanga) 66 Ekurhuleni (Gauteng) 65 Metsweding (Gauteng) 64 Limpopo (Limpopo) 60 Uthungulu (KZN) 56 Gert Sibande (Mpumalanga) 53 Fezile Dabi (Free State) 49 Capricorn (Limpopo) 43 Thabo Mofutsanyane (Free State) 39 Ukhahlamba (Eastern Cape) 32 Amajuba (KZN) 32 Umkhanyakude (KZN) 32 Namakwa (Northern Cape) 31 South North West (North West) 24 Ugu (KZN) 23 iLembe (KZN) 23 Vhembe (Limpopo) 23 Sisonke (KZN) 22 Lejweleputswa (Free State) 19 Xhariep (Free State) 19 Greater Sekhukhune (Limpopo) 19 O.R. Tambo (Eastern Cape) 18 Chris Hani (Eastern Cape) 17 Central Karoo (Western Cape) 16 Zululand (KZN) 13 Umzinyathi (KZN) 9 Pixley ka Seme (Northern Cape) 8 Siyanda (Northern Cape) 8 Frances Baard (Northern Cape) 7 Kgalagadi (Northern Cape) 4 Bophirima (North West) 2 Central North West (North West) 2 Alfred Nzo (Eastern Cape) 0 Only one, Alfred Nzo, in the north east of the Eastern Cape has no caches. Link to comment
+cincol Posted February 11, 2010 Share Posted February 11, 2010 (edited) Distribution of caches i.t.o. District Municipalities The number of caches in each of the 52 District and Metropolitan municipalities of South Africa: Cape Town (Western Cape) 481 eThekwini (KZN) 306 Ehlanzeni (Mpumalanga) 294 Johannesburg (Gauteng) 286 Tshwane (Gauteng) 242 Amatole (Eastern Cape) 188 Boland (Western Cape) 136 Overberg (Western Cape) 122 Cacadu (Eastern Cape) 121 Bojanala (North West) 119 Eden (Western Cape) 96 Uthukela (KZN) 93 ...................................................... Only one, Alfred Nzo, in the north east of the Eastern Cape has no caches. UUHH - no offense meant, but where on earth are these places??? I think I have been away from SA for too long! Edited February 11, 2010 by cincol Link to comment
+DamhuisClan Posted February 11, 2010 Share Posted February 11, 2010 Wow! Danie you are taking the stats to a new level. Way to go! Link to comment
+Danie Viljoen Posted February 11, 2010 Share Posted February 11, 2010 UUHH - no offense meant, but where on earth are these places??? I think I have been away from SA for too long! See http://www.demarcation.org.za/ Link to comment
+Nadia & Co. Posted February 25, 2010 Share Posted February 25, 2010 Thank you for this info... I have read about Gauteng stagnating after deciding to place at least one cache today, now just hope the rain clears... Link to comment
+tomtwogates Posted February 25, 2010 Share Posted February 25, 2010 Distribution of caches i.t.o. District Municipalities The number of caches in each of the 52 District and Metropolitan municipalities of South Africa: Cape Town (Western Cape) 481 GO Cape Town! Link to comment
+Happy Hunters SA Posted February 25, 2010 Share Posted February 25, 2010 We have placed 17 caches since 12/12/09 Will do some more in April when were back from doing some of the Durban caches on our vacation Link to comment
+Boris Posted February 25, 2010 Share Posted February 25, 2010 Now that the addlogs macro does not work for updating the logs on caches in the GSAK database, does anyone know of a way to add logs, to a cache record in GSAK, manually? Thanks for the help. Boris Link to comment
+Happy Hunters SA Posted February 25, 2010 Share Posted February 25, 2010 Now that the addlogs macro does not work for updating the logs on caches in the GSAK database, does anyone know of a way to add logs, to a cache record in GSAK, manually? Thanks for the help. Boris How does the add log macro not work? Link to comment
+Boris Posted February 25, 2010 Share Posted February 25, 2010 Now that the addlogs macro does not work for updating the logs on caches in the GSAK database, does anyone know of a way to add logs, to a cache record in GSAK, manually? Thanks for the help. Boris How does the add log macro not work? If you run it on a cache that you do not own it comes up with a 'macro cancelled message' - something about changes on the GC.com site earlier this year. Link to comment
+Happy Hunters SA Posted February 25, 2010 Share Posted February 25, 2010 Hi Boris I did have a look at your profile and i see you have not updated your macros lately. That you can see when you look at the provincial map of South Africa and the totals of each provence thats not where they are supposed to be. So when you run your macros, click on Version and then ALL . This will update all your existin macros. Should not have any problems running your add logs. Link to comment
+Happy Hunters SA Posted February 25, 2010 Share Posted February 25, 2010 As I thought.. There is a new version of Add Logs Ver2.21 Link to comment
+Boris Posted February 25, 2010 Share Posted February 25, 2010 As I thought.. There is a new version of Add Logs Ver2.21 I have just updated to that version - I was a version behind - and it is still giving the same error message - if you look at the macro page it explains the changes this year. So only able to run this macro on caches you own. I know that you can manually get the last 20 logs on a cache by downloading the gpx file from the cache listing on GC.com, but don't know how to get older logs than that. Thanks for the help. Link to comment
+Happy Hunters SA Posted February 25, 2010 Share Posted February 25, 2010 As I thought.. There is a new version of Add Logs Ver2.21 I have just updated to that version - I was a version behind - and it is still giving the same error message - if you look at the macro page it explains the changes this year. So only able to run this macro on caches you own. I know that you can manually get the last 20 logs on a cache by downloading the gpx file from the cache listing on GC.com, but don't know how to get older logs than that. Thanks for the help. I am aware of the hard coding. I did not realise you wanted to add loggs on caches that you dont own. I have not tried to add more than 20 loggs as yet. And I am not sure if this is possible. The best advice I can give you is to post a thread on the gsak forum and see if you receive a answer on your question. Link to comment
+Danie Viljoen Posted February 25, 2010 Share Posted February 25, 2010 I do not think there is any (legal) way to add more than the last 20 logs of caches owned by somebody else. Frequent Pocket Queries appear to be the only easy solution for now. Link to comment
+Boris Posted February 25, 2010 Share Posted February 25, 2010 I do not think there is any (legal) way to add more than the last 20 logs of caches owned by somebody else. Frequent Pocket Queries appear to be the only easy solution for now. Thanks Danie Link to comment
+Jors Posted February 25, 2010 Share Posted February 25, 2010 (edited) Boris, I have not tried it myself, but the macro Createlog.gsk (click here) might work with some copy/pasting. Plese let me know if it works for you. Edited February 25, 2010 by Jors Link to comment
+Carbon Hunter Posted March 1, 2010 Author Share Posted March 1, 2010 OK - without using GSAK - is there a tool that I can get stats from my own hides? I'd like to know a few basic stats only Most finds Ave Finds Total finds per cache Thanks in advance Link to comment
Recommended Posts