Go to Post ...if you don't ask, you won't get. - Billfred [more]
Home
Go Back   Chief Delphi > CD-Media > Photos
CD-Media   CD-Spy  
portal register members calendar search Today's Posts Mark Forums Read FAQ rules

photos

papers

everything



US First Map (Teams per State)

logank013

By: logank013
New: 09-23-2015 08:25 PM
Updated: 09-23-2015 08:25 PM
Views: 1398 times


US First Map (Teams per State)

So... Today, I got bored so as a FIRSTer who loves statistics, I causally decided to make a map. Just going to say that entering in each state's abbreviation was rough; I had to go back to 7th grade History and look some up. Haha. Enjoy!

Code:
Alabama.....9
Alaska.....1
Arizona.....52
Arkansas.....18
California.....238
Colorado.....35
Connecticut.....47
Delaware.....4
Florida.....64
Georgia.....60
Hawaii.....26
Idaho.....13
Illinois.....58
Indiana.....49
Iowa.....9
Kansas.....22
Kentucky.....12
Louisiana.....27
Maine.....21
Maryland.....36
Massachusetts.....64
Michigan.....345
Minnesota.....192
Mississippi.....8
Missouri.....69
Montana.....2
Nebraska.....0
Nevada.....10
New Hampshire.....33
New Jersey.....73
New Mexico.....5
New York.....147
North Carolina.....50
North Dakota.....3
Ohio.....56
Oklahoma.....48
Oregon.....43
Pennsylvania.....74
Rhode Island.....6
South Carolina.....41
South Dakota.....2
Tennessee.....45
Texas.....136
Utah.....20
Vermont.....3
Virginia.....75
Washington.....109
West Virginia.....4
Wisconsin.....41
Wyoming.....4
Washington D.C......13
Puerto Rico.....1 (U.S. FIRST counts Puerto Rico as apart of the U.S.)

Recent Viewers

  • Guest

Discussion

view entire thread

Reply

09-24-2015 12:44 PM

MattRain


Unread Re: pic: US First Map (Teams per State)

Looks awesome. I'm guessing this is based on FRC teams, as I know our state as alot more teams than whats listed.



09-24-2015 01:17 PM

RamZ


Unread Re: pic: US First Map (Teams per State)

Looks great, thanks for making this! I'm actually in the process of making an interactive site with this info as web design practice.



09-24-2015 01:19 PM

marshall


Unread Re: pic: US First Map (Teams per State)

THANK YOU!

I've been wanting this for a long time. Excellent work!



09-24-2015 03:06 PM

BBray_T1296


Unread Re: pic: US First Map (Teams per State)

Quote:
Originally Posted by MattRain View Post
Looks awesome. I'm guessing this is based on FRC teams, as I know our state as alot more teams than whats listed.
Indeed. Expect the teams/state to be in the thousands for many states if you included FTC/FLL/jFLL



09-24-2015 03:27 PM

James1902


Unread Re: pic: US First Map (Teams per State)

Has anyone done a "Teams/Square Mile" of each state? It'd be interesting to see the team density in district areas vs. regional areas.



09-24-2015 03:34 PM

logank013


Unread Re: pic: US First Map (Teams per State)

Quote:
Originally Posted by MattRain View Post
Looks awesome. I'm guessing this is based on FRC teams, as I know our state as alot more teams than whats listed.
Haha, Yes. Sometimes I Forget that there are also FTC teams and FLL Teams. These are strictly FRC Teams!



09-24-2015 03:40 PM

logank013


Unread Re: pic: US First Map (Teams per State)

Quote:
Originally Posted by James1902 View Post
Has anyone done a "Teams/Square Mile" of each state? It'd be interesting to see the team density in district areas vs. regional areas.
I actually was considering doing that so sometimes this weekend when I get bored, I'll do the math and probably multiply it by some fraction to make it easier to read so it won't be like ".00003423" haha. Michigan and Connecticut will probably be the most dense based of my guesses.



09-24-2015 03:46 PM

mwmac


Unread Re: pic: US First Map (Teams per State)

I would bet Alaska is the least dense. That is before their incorporation into PNW.



09-24-2015 03:48 PM

James1902


Unread Re: pic: US First Map (Teams per State)

Quote:
Originally Posted by logank013 View Post
Michigan and Connecticut will probably be the most dense based of my guesses.
I'd throw Hawaii into the list of potential contenders as well.



09-24-2015 03:52 PM

Darkseer54


Unread Re: pic: US First Map (Teams per State)

Pretty sure Nebraska is the least dense.



09-24-2015 04:29 PM

logank013


Unread Re: pic: US First Map (Teams per State)

Quote:
Originally Posted by Darkseer54 View Post
Pretty sure Nebraska is the least dense.
0 straight across...haha



09-24-2015 06:43 PM

Zach101


Unread Re: pic: US First Map (Teams per State)

Best thing about Minnesota is that we have more FRC teams than high school hockey teams.



09-24-2015 07:41 PM

Sperkowsky


Unread Re: pic: US First Map (Teams per State)

Quote:
Originally Posted by logank013 View Post
I actually was considering doing that so sometimes this weekend when I get bored, I'll do the math and probably multiply it by some fraction to make it easier to read so it won't be like ".00003423" haha. Michigan and Connecticut will probably be the most dense based of my guesses.
NYC and Long island (Lower NY) would be very dense as well I know its not a state but to people from here its so different it might as well be its own small state.

Within 5 miles of my house there is 4 teams
2869 - Bethpage Regak Eagles (My team)
353 - Plainvew/Old Bethpage PoBots
1468 - Hicksville JBirds
527 - Plainedge Red Dragons



09-25-2015 10:14 AM

MARS_James


Unread Re: pic: US First Map (Teams per State)

Quote:
Originally Posted by James1902 View Post
Has anyone done a "Teams/Square Mile" of each state? It'd be interesting to see the team density in district areas vs. regional areas.
As opposed to dealing with formatting on chiefdelphi, here is a Link to a Google Doc, that lists the team density based on land mass of each state (Plus DC and Puerto Rico). DC and Jersey are top two, while Alaska and Nebraska are the bottom 2. Later on I will calculate multistate districts later on (Alaska will not count as PNW since that would really skew those numbers)



09-25-2015 10:48 AM

sdangelo


Unread Re: pic: US First Map (Teams per State)

Quote:
Originally Posted by MARS_James View Post
here is a Link to a Google Doc, that lists the team density based on land mass of each state
Here's a map made from the negative log of those densities. The value for DC was so much higher than all the other regions that just using the straight values showed nearly all the states as the same color. Puerto Rico and DC not currently included, unfortunately. I'll see if I can get DC to work, at least.
Dark blue = highest density, bright green = lowest density, yellow = no teams



09-25-2015 11:01 AM

MattRain


Unread Re: pic: US First Map (Teams per State)

Quote:
Originally Posted by logank013 View Post
Haha, Yes. Sometimes I Forget that there are also FTC teams and FLL Teams. These are strictly FRC Teams!
FIRST forgets about us too. (I kid.... sorta)



09-25-2015 11:45 AM

346CADmen


Unread Re: pic: US First Map (Teams per State)

Quote:
Originally Posted by Zach101 View Post
Best thing about Minnesota is that we have more FRC teams than high school hockey teams.

If that is a qualifier, than Virginia has you beat. And guessing many others would beat VA.

But, to the powers that be, please don't let that pull the reins on a hockey based FRC game, where frozen water would be as close to a water game as we can get.



09-25-2015 11:59 AM

tindleroot


Unread Re: pic: US First Map (Teams per State)

Quote:
Originally Posted by 346CADmen View Post
If that is a qualifier, than Virginia has you beat. And guessing many others would beat VA.
I don't think hockey is a religion in Virginia...



09-25-2015 12:55 PM

logank013


Unread Re: pic: US First Map (Teams per State)

Quote:
Originally Posted by sdangelo View Post
Here's a map made from the negative log of those densities. The value for DC was so much higher than all the other regions that just using the straight values showed nearly all the states as the same color. Puerto Rico and DC not currently included, unfortunately. I'll see if I can get DC to work, at least.
Dark blue = highest density, bright green = lowest density, yellow = no teams
How did you get the excel file to become just an image. I made a map but I'm not sure how you got rid of the boxes behind the image



09-25-2015 01:59 PM

sdangelo


Unread Re: pic: US First Map (Teams per State)

Quote:
Originally Posted by MattRain View Post
FIRST forgets about us too. (I kid.... sorta)
I don't forget about you! Map doc has been updated. The 2nd sheet is an FTC map, 3rd is FLL. Same color scheme as before.

Quote:
Originally Posted by logank013 View Post
How did you get the excel file to become just an image. I made a map but I'm not sure how you got rid of the boxes behind the image
I didn't use Excel, everything was right in Google Sheets. In Google Sheets, after you insert a chart, you can click on a little arrow in the top right corner of the chart to get a drop down menu. There's an option that says "Move to own sheet...". I don't know if it's the same in Excel, but I hope that helps.



09-25-2015 02:44 PM

logank013


Unread Re: pic: US First Map (Teams per State)

Hey guys. Please do not post on this thread anymore! Due to not being able to edit the main post in this thread, I started a new thread! The new thread is here:
http://www.chiefdelphi.com/forums/sh...hreadid=138294



09-27-2015 10:19 PM

Andrew Schuetze


Unread Re: pic: US First Map (Teams per State)

Quote:
Originally Posted by Zach101 View Post
Best thing about Minnesota is that we have more FRC teams than high school hockey teams.
Same goes for Texas but that is a pretty low standard in our area



09-27-2015 10:22 PM

logank013


Unread Re: pic: US First Map (Teams per State)

Quote:
Originally Posted by Andrew Schuetze View Post
Same goes for Texas but that is a pretty low standard in our area
Haha cool. Go to http://www.chiefdelphi.com/forums/sh...hreadid=138294 if you want to see my other maps



09-27-2015 10:39 PM

wireties


Unread Re: pic: US First Map (Teams per State)

Number of teams vs population density would be kewl.



09-27-2015 10:40 PM

logank013


Unread Re: pic: US First Map (Teams per State)

Quote:
Originally Posted by wireties View Post
Number of teams vs population density would be kewl.
I already have that map. Go here http://www.chiefdelphi.com/forums/sh...hreadid=138294 for all my maps. This is an old thread.



09-28-2015 09:43 AM

Christopher149


Unread Re: pic: US First Map (Teams per State)

Looks like we might have an FRC team from Nebraska this year - 5906 from somewhere, NE, competing at the Iowa Regional.



09-28-2015 09:48 AM

Tom Ore


Unread Re: pic: US First Map (Teams per State)

Quote:
Originally Posted by Christopher149 View Post
Looks like we might have an FRC team from Nebraska this year - 5906 from somewhere, NE, competing at the Iowa Regional.
I believe they are from the Omaha area.



09-28-2015 09:04 PM

logank013


Unread Re: pic: US First Map (Teams per State)

Quote:
Originally Posted by Christopher149 View Post
Looks like we might have an FRC team from Nebraska this year - 5906 from somewhere, NE, competing at the Iowa Regional.
Where are you finding rookie team lists? I'm curious. Thanks



09-28-2015 09:05 PM

EricH


Unread Re: pic: US First Map (Teams per State)

Quote:
Originally Posted by logank013 View Post
Where are you finding rookie team lists? I'm curious. Thanks
You just need to know what the lowest rookie team number this year is--I believe it's 5800. Any team with a higher number is a rookie.



09-28-2015 09:09 PM

logank013


Unread Re: pic: US First Map (Teams per State)

Quote:
Originally Posted by EricH View Post
You just need to know what the lowest rookie team number this year is--I believe it's 5800. Any team with a higher number is a rookie.
Thanks. Does TBA or another source have the locations of all the teams? TBA didn't have the locations of each team posted.



09-28-2015 09:11 PM

EricH


Unread Re: pic: US First Map (Teams per State)

Quote:
Originally Posted by logank013 View Post
Thanks. Does TBA or another source have the locations of all the teams? TBA didn't have the locations of each team posted.
I just found that out myself--I suspect the answer is "they will shortly".

You might also try asking Mark McLeod.



09-28-2015 11:10 PM

Christopher149


Unread Re: pic: US First Map (Teams per State)

Quote:
Originally Posted by logank013 View Post
Where are you finding rookie team lists? I'm curious. Thanks
http://frclinks.com/t/, sort by team number, scroll to the highest numbers.



view entire thread

Reply
previous
next

Tags

loading ...



All times are GMT -5. The time now is 01:35 PM.

The Chief Delphi Forums are sponsored by Innovation First International, Inc.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright © Chief Delphi