Joyful April Posted March 24, 2008 Posted March 24, 2008 I would love to run a simply query directly on the Groundspeak database. I want to see how many active caches per state. How do I figure it out without hacking into the Groundspeak database *kidding *kidding *kidding!!! ( I wouldn't know how to do it even if I wanted to do it). Any ideas? Thank you. Quote
+Stunod Posted March 24, 2008 Posted March 24, 2008 Go to the HIDE & SEEK A CACHE page and choose a state from the pull-down menu. At the top of the resulting page you will see: Total Records: #### - Page: 1 of ### Hope that helps Quote
+Bamboogirl Posted March 24, 2008 Posted March 24, 2008 A more interesting query may be cache density per square mile. As Wacka said, California would probably be way up on the list. But would that be because of the big number of square miles as compared to other states? Quote
+Bamboogirl Posted March 24, 2008 Posted March 24, 2008 Clearly I need to take a walk or something. I looked at 5 states strictly for quantity of caches. The divided by the sqare miles of same states. Rhode Island actually has a greater cache density than California. Useless information? I think so. Alabama: 0.089 Alaska: 0.003 California: 0.300 Idaho: 0.067 Rhode Island: 0.493 Quote
sdarken Posted March 24, 2008 Posted March 24, 2008 (edited) I copied this table out of a forum thread earlier this year (but I didn't note the URL of the thread). The formatting got a bit messed up but it shows states listed in descending cache density. eg: DC has 88 caches in 68 square miles for an average of 1.28 caches per square mile, CA has 47072 caches in 163,696 square miles for an average of .28 caches per square mile. STATE CACHES AREA DENSITY DC 88 68 1.288433382 RI 702 1,214 0.578253707 CT 2917 5,543 0.526249323 NJ 3959 8,721 0.453961702 MA 4255 10,555 0.40312648 DE 893 2,489 0.358778626 NH 2915 9,350 0.311764706 CA 47072 163,696 0.287557424 MD 3096 12,407 0.249536552 PA 10340 46,055 0.224514168 OH 10046 44,825 0.224116007 IN 8159 36,418 0.224037564 FL 14417 65,755 0.219253289 NC 10630 53,819 0.197513889 TN 8276 42,143 0.196378995 NY 10054 54,556 0.184287704 WA 11546 71,300 0.161935484 VA 6174 42,774 0.14434002 VT 1280 9,614 0.133139172 IL 7141 57,914 0.123303519 I'd be interested to see a similar chart based on density compared to population but I'm too lazy to make one myself. Edited March 24, 2008 by sdarken Quote
Joyful April Posted March 25, 2008 Author Posted March 25, 2008 Go to the HIDE & SEEK A CACHE page and choose a state from the pull-down menu. At the top of the resulting page you will see: Total Records: #### - Page: 1 of ### Hope that helps Thanks. That was an easy solution. Quote
Joyful April Posted March 25, 2008 Author Posted March 25, 2008 Clearly I need to take a walk or something. I looked at 5 states strictly for quantity of caches. The divided by the sqare miles of same states. Rhode Island actually has a greater cache density than California. Useless information? I think so. Alabama: 0.089 Alaska: 0.003 California: 0.300 Idaho: 0.067 Rhode Island: 0.493 That's the kind of info that I like. Thank you! Quote
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.