Jump to content

I want to see how many active caches per state.


Recommended Posts

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.

Link to comment

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

Link to comment

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 by sdarken
Link to comment

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!

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...