#1  
Old 02-24-2014, 01:29 PM
Lewis's Avatar
Lewis Lewis is offline
* Ace Member *
 
Join Date: Sep 2008
Location: Marietta, GA
Years Playing: 7.1
Courses Played: 16
Throwing Style: RHBH
Posts: 4,042
US map showing density of course in each state

I've been wanting to figure out a way to show survey data by state, like you see in all those infographics on the internet about who says "soda" and who says "pop". After some research on how to do it in Excel, I finally figured out a way. While doing this, I created a map to show the density of disc golf courses per state, which I've attached as an image. I was kinda surprised to see how well, for example, Delaware, which has only 12 courses, compares against Texas, which has over 300, when you adjust for land area. Check it out and see if you notice anything interesting.
Attached Images
File Type: png dg-course-density-of-states.png (95.3 KB, 1048 views)
Reply With Quote
  #2  
Old 02-24-2014, 01:32 PM
Lewis's Avatar
Lewis Lewis is offline
* Ace Member *
 
Join Date: Sep 2008
Location: Marietta, GA
Years Playing: 7.1
Courses Played: 16
Throwing Style: RHBH
Posts: 4,042
The map looks a little better against a white background (open it in a new browser tab), because of the transparent color setting in the image. I should have turned that off when I saved it.
Reply With Quote
  #3  
Old 02-24-2014, 01:36 PM
bradharris's Avatar
bradharris bradharris is online now
Banned From the Trilogy
 
Join Date: Apr 2011
Location: Merrimack, NH
Years Playing: 11.3
Courses Played: 70
Posts: 4,147
That is interesting. I'm surprised NH isn't more red, but we are a pretty small state.

Another interesting way to go about it would be to look at number of courses within X miles on any point on the map. So rather than state-by-state, you would have gradients that darken in high density regions, and lighten in lower density areas. I imagine that would be a very difficult map to make though.
Reply With Quote
  #4  
Old 02-24-2014, 01:36 PM
brian j's Avatar
brian j brian j is offline
Eagle Member
 
Join Date: Aug 2008
Location: Virginia
Years Playing: 6.1
Courses Played: 70
Throwing Style: RHBH
Posts: 741
it'd be nice to see a scale so that i know what the various colors represent.
Reply With Quote
  #5  
Old 02-24-2014, 01:37 PM
kaiser flippin's Avatar
kaiser flippin kaiser flippin is offline
Double Eagle Member
 
Join Date: Jan 2012
Location: Eastern Oregon
Years Playing: 5.1
Courses Played: 22
Throwing Style: RHBH
Posts: 1,652
Rhode island need to get it together. You'd think they'd have an advantage here.
Reply With Quote
  #6  
Old 02-24-2014, 01:37 PM
brian j's Avatar
brian j brian j is offline
Eagle Member
 
Join Date: Aug 2008
Location: Virginia
Years Playing: 6.1
Courses Played: 70
Throwing Style: RHBH
Posts: 741
Quote:
Originally Posted by brian j View Post
it'd be nice to see a scale so that i know what the various colors represent.
sorry, didn't mean to sound like a richard.
Reply With Quote
  #7  
Old 02-24-2014, 01:43 PM
Lewis's Avatar
Lewis Lewis is offline
* Ace Member *
 
Join Date: Sep 2008
Location: Marietta, GA
Years Playing: 7.1
Courses Played: 16
Throwing Style: RHBH
Posts: 4,042
Quote:
Originally Posted by bradharris View Post
That is interesting. I'm surprised NH isn't more red, but we are a pretty small state.

Another interesting way to go about it would be to look at number of courses within X miles on any point on the map. So rather than state-by-state, you would have gradients that darken in high density regions, and lighten in lower density areas. I imagine that would be a very difficult map to make though.
Yeah that would take a lot of time and data, and I'm not sure Excel could handle as many tiny little shapes as you'd want to use. You might could do it by county, but I don't have any easy way to look up courses by county.

Quote:
Originally Posted by brian j View Post
it'd be nice to see a scale so that i know what the various colors represent.
Sorry I omitted that. The state with the least course density (Alaska) is the reddest, and the state with the greatest course density (Delaware) is the greenest. All the others are colored according to their relative density vs. Alaska and Delaware. I suppose I could set it up on an evenly graduated scale, but I haven't done that with the spreadsheet at this point. Maybe I can share an updated version if you want, or share my spreadsheet and let you tinker with it.
Reply With Quote
  #8  
Old 02-24-2014, 01:43 PM
turbosteve's Avatar
turbosteve turbosteve is offline
Eagle Member
 
Join Date: Jun 2011
Location: Rock Hill/Columbia SC
Years Playing: 3.3
Courses Played: 59
Throwing Style: RHBH
Posts: 696
Can you do another one showing courses per-capita of population so we can compare the two?
Reply With Quote
  #9  
Old 02-24-2014, 01:44 PM
optidiscic's Avatar
optidiscic optidiscic is offline
* Ace Member *
 
Join Date: Dec 2008
Location: Discopolis Pennsylvania
Years Playing: 12.2
Courses Played: 155
Posts: 6,476
Send a message via Yahoo to optidiscic
Delaware is quite bright green
Reply With Quote
 

  #10  
Old 02-24-2014, 01:46 PM
Kenny53691's Avatar
Kenny53691 Kenny53691 is offline
Noodle Arm
 
Join Date: Jul 2010
Location: West of Dayton, OH
Years Playing: 4.4
Courses Played: 64
Throwing Style: RHBH
Posts: 1,689
WOOT!!! GO OHIO!!!!
Reply With Quote
Reply

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 09:17 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.