Chief Delphi

Chief Delphi (http://www.chiefdelphi.com/forums/index.php)
-   General Forum (http://www.chiefdelphi.com/forums/forumdisplay.php?f=16)
-   -   FRC "Population" Maps (http://www.chiefdelphi.com/forums/showthread.php?t=108054)

EllaElectrical 28-08-2012 10:27

FRC "Population" Maps
 
I made several maps (with a lot of help from google :D ) that kind of show the population density of FRC teams in the United States and the world. The maps are pictures, they used to be charts but it would take several hours for them to load. :)
https://docs.google.com/spreadsheet/...HhHW Wc#gid=5

Wayne TenBrink 28-08-2012 12:47

Re: FRC "Population" Maps
 
Very cool. Thanks for putting this together.

I am struck by the difference between Minnesota and Iowa.

jwallace15 28-08-2012 13:20

Re: FRC "Population" Maps
 
I'm not sure on the exact number, but approximately 34 of Michigan's teams come from 1 county- Oakland. That's more than 22 states!

EllaElectrical 28-08-2012 13:24

Re: FRC "Population" Maps
 
No problem :)
Yeah when I was making it ,it was really crazy to see the differences between different states. And where the "population density" was really high.

dk5sm5luigi 28-08-2012 14:06

Re: FRC "Population" Maps
 
You should try to make one that does the states by percentage of schools covered.

MARS_James 28-08-2012 14:40

Re: FRC "Population" Maps
 
Quote:

Originally Posted by dk5sm5luigi (Post 1183404)
You should try to make one that does the states by percentage of schools covered.

That would be really challenging considering the multiple school teams that don't have all the schools in the name (We are an example since we have Jupiter and William T. Dwyer High Schools in our name, but also recruit from 5 other schools) or teams that don't have have schools like the boys and girls clubs

dk5sm5luigi 28-08-2012 14:48

Re: FRC "Population" Maps
 
Quote:

Originally Posted by MARS_James (Post 1183410)
That would be really challenging considering the multiple school teams that don't have all the schools in the name (We are an example since we have Jupiter and William T. Dwyer High Schools in our name, but also recruit from 5 other schools) or teams that don't have have schools like the boys and girls clubs

I never said it would be easy, it would put things in perspective though. Small states right now look like they don't have as many teams even though they may have a larger percentage covered.

EllaElectrical 28-08-2012 14:55

Re: FRC "Population" Maps
 
Quote:

Originally Posted by dk5sm5luigi (Post 1183411)
I never said it would be easy, it would put things in perspective though. Small states right now look like they don't have as many teams even though they may have a larger percentage covered.

Yes it probably would take a while but it's a good idead. I'll start trying to make a basic high school percentage map. Because you are right my maps aren't in the best perspective. One of my team mates also brought up a map that showed percentage of teams near major cities for another perspective.

dodar 28-08-2012 15:01

Re: FRC "Population" Maps
 
Quote:

Originally Posted by MARS_James (Post 1183410)
That would be really challenging considering the multiple school teams that don't have all the schools in the name (We are an example since we have Jupiter and William T. Dwyer High Schools in our name, but also recruit from 5 other schools) or teams that don't have have schools like the boys and girls clubs

Teams wih multiple schools wouldnt matter. All you would do is take (# of teams/# of high schools in the state)*100 = % of teams per school per state.

ehochstein 28-08-2012 15:04

Re: FRC "Population" Maps
 
Awesome numbers!

Quote:

Originally Posted by Wayne TenBrink (Post 1183395)
Very cool. Thanks for putting this together.

I am struck by the difference between Minnesota and Iowa.

I can't see the map from work but I was at the Minnesota State Fair's FIRST booth for most of Saturday and I spoke to two leaders of a new FRC team in Iowa, they said something about a FRC regional in Iowa next year. I am thinking they were maybe confused between FRC and FTC but it would be awesome if we had an FRC regional in Iowa! Not entirely sure how they would do it with 4 veteran teams, but still.

MARS_James 28-08-2012 15:32

Re: FRC "Population" Maps
 
Quote:

Originally Posted by dodar (Post 1183417)
Teams wih multiple schools wouldnt matter. All you would do is take (# of teams/# of high schools in the state)*100 = % of teams per school per state.

The original statement was percentage of schools covered not the percentage of teams in relations to schools so yes multiple school teams do matter

dodar 28-08-2012 15:39

Re: FRC "Population" Maps
 
Quote:

Originally Posted by MARS_James (Post 1183420)
The original statement was percentage of schools covered not the percentage of teams in relations to schools so yes multiple school teams do matter

Oh, ya I missread the post. You could still do it that way though. On the FIRST website, each school per team is listed as a sponsor.

Racer26 28-08-2012 15:52

Re: FRC "Population" Maps
 
Also kind of cool: Toronto has the 2nd highest concentration of any city. FIRST still USA-centric? No.

Racer26 28-08-2012 16:07

Re: FRC "Population" Maps
 
City, Teams, Population, Est. Percentage of population on a FIRST team

(based on 20 members per team)

Check out Liberty, IN. 11 1 team(s) in a town of 2133 people, for an estimated FIRST participation of 10% 1% of the population!
Code:

Houston, TX, USA        30        2145146        0.0280%
Toronto, ON, Canada        29        2615060        0.0222%
Chicago, IL, USA        28        2707120        0.0207%
Detroit, MI, USA        26        706585        0.0736%
Montréal, QC, Canada        19        1649519        0.0230%
Washington, DC, USA        18        617996        0.0583%
San Antonio, TX, USA        18        1359758        0.0265%
San Diego, CA, USA        17        1326179        0.0256%
Kansas City, MO, USA        16        463202        0.0691%
Honolulu, HI, USA        16        374658        0.0854%
Atlanta, GA, USA        16        432427        0.0740%
San Jose, CA, USA        15        967487        0.0310%
Rochester, NY, USA        13        210855        0.1233%
Phoenix, AZ, USA        13        1469471        0.0177%
Dallas, TX, USA        13        1223229        0.0213%
Bronx, NY, USA        13        1392002        0.0187%
Milwaukee, WI, USA        12        597867        0.0401%
Los Angeles, CA, USA        12        3819702        0.0063%
Las Vegas, NV, USA        12        589317        0.0407%
Columbus, OH, USA        12        797434        0.0301%
Baltimore, MD, USA        12        619493        0.0387%
New York, NY, USA        11        8244910        0.0027%
Liberty, IN, USA        1        2133        0.9376%
Brooklyn, NY, USA        11        2532645        0.0087%
St. Louis, MO, USA        10        318069        0.0629%
Richmond, VA, USA        10        205533        0.0973%
Portland, OR, USA        10        593820        0.0337%
Mississauga, ON, Canada        10        713443        0.0280%
Minneapolis, MN, USA        10        387753        0.0516%
Denver, CO, USA        10        619968        0.0323%

Edit: Helps when the source information is valid. There's a problem with your numbers, there is only one team, 4058, in Liberty, IN. 1% is still impressive though! (source: https://my.usfirst.org/myarea/index....2E#FRC_te ams)

Mark McLeod 28-08-2012 16:26

Re: FRC "Population" Maps
 
I don't think Brooklyn, Queens, Staten Island, or the Bronx count as cities separate from New York City...

EricH 28-08-2012 16:44

Re: FRC "Population" Maps
 
Quote:

Originally Posted by Mark McLeod (Post 1183429)
I don't think Brooklyn, Queens, Staten Island, or the Bronx count as cities separate from New York City...

Which highlights the one major problem with the FIRST website location column: The teams fill it out, which means that sometimes you get addresses, and sometimes you get regions. 12 teams in Los Angeles--but if you look at the area around L.A. proper, there are easily enough for 2 small regionals with minimal outside or repeat teams. (And I know that one of the teams at least used to use "Southern California" as their location--talk about vague!) You're also hoping that nobody misspells their team name.

Nate Laverdure 28-08-2012 16:56

Re: FRC "Population" Maps
 
Quote:

Originally Posted by EricH (Post 1183430)
Which highlights the one major problem with the FIRST website location column...

...Which is why Mark at 358 has been collecting more accurate team locations (in the form of the GPS coordinates of each team's school) in his All FRC Teams Ever (XLS link) spreadsheet. He's got just over 20% of them now.

Jon Stratis 28-08-2012 16:57

Re: FRC "Population" Maps
 
Another oddity...

St. Paul, MN - 6
Saint Paul, MN - 5


1075guy, where do your population numbers come from?

In doing an analysis against population, does it make sense to look at numbers by city or some other grouping? Most major cities have significant suburbs that would show up as different cities on the listing. For example, Woodbury, MN has 3 teams, and is about 5 minutes from downtown St. Paul. These suburbs typically have lower population numbers, but could contribute significantly to the number of teams around that city.

Given the data available to us, doing it might be best to do it by state.

EllaElectrical 28-08-2012 17:26

Re: FRC "Population" Maps
 
Quote:

Originally Posted by Jon Stratis (Post 1183434)
Another oddity...

St. Paul, MN - 6
Saint Paul, MN - 5


1075guy, where do your population numbers come from?

In doing an analysis against population, does it make sense to look at numbers by city or some other grouping? Most major cities have significant suburbs that would show up as different cities on the listing. For example, Woodbury, MN has 3 teams, and is about 5 minutes from downtown St. Paul. These suburbs typically have lower population numbers, but could contribute significantly to the number of teams around that city.

Given the data available to us, doing it might be best to do it by state.

Hmm true I have another spreadsheet of all my numbers I'll check through for errors like this and make another map (looking at the other errors people have pointed out). I got the places from blue alliance then totaled then manually, which is why I have some errors like that and Liberty, IN (sorry about that by the way).

Mark McLeod 28-08-2012 18:07

Re: FRC "Population" Maps
 
Another problem is duplicate teams. Your tally has 293 more teams than there really are (2339).
Hauppauge, NY for instance is in the list twice, but it only hosts a single team.

EllaElectrical 28-08-2012 19:03

Re: FRC "Population" Maps
 
Quote:

Originally Posted by Mark McLeod (Post 1183436)
Another problem is duplicate teams. Your tally has 293 more teams than there really are (2339).
Hauppauge, NY for instance is in the list twice, but it only hosts a single team.


Okay, yeah thanks I'm not sure how they happened but hopefully I'll be able to update most of it later tonight. :)

JamesC 28-08-2012 20:10

Re: FRC "Population" Maps
 
Hey All,

Just for fun, here's all of the teams active in 2012 plotted on a Google Maps interactive plot.

http://batchgeo.com/map/7a90e9236610...640cbca7d36d9d

Data is based on the Lat/Lon coordinates from the All FRC Teams Ever xls file provided by Mark from 358 and Nate from 122!

Apologies if your version is as slow as mine, maybe there's too many teams these days...

Cheers!

BJT 28-08-2012 20:27

Re: FRC "Population" Maps
 
You have some teams that have folded quite a while ago. I see about 5 in ND, but as of last year only 2 were still going.

connor.worley 28-08-2012 21:44

Re: FRC "Population" Maps
 
Cool, but the total team count seems low.

Racer26 29-08-2012 10:40

Re: FRC "Population" Maps
 
Quote:

Originally Posted by Jon Stratis (Post 1183434)
1075guy, where do your population numbers come from?

Google cityname population. Most of them were 2011 census numbers, shown as the top result.

Was trying to evaluate teams by density. Teams per capita, if you will.

To have two Canadian cities in the top 5 is impressive though. There's a reason
Canada has been consistently producing world-class robots.

What would also be interesting is a FIRST teams divided by highschools in a city. That would show FIRST penetration in terms of the FIRST team in every school goal.

jwallace15 29-08-2012 11:21

Re: FRC "Population" Maps
 
Quote:

Originally Posted by JamesC (Post 1183449)
Hey All,

Just for fun, here's all of the teams active in 2012 plotted on a Google Maps interactive plot.

http://batchgeo.com/map/7a90e9236610...640cbca7d36d9d

Quote:

Originally Posted by BJT (Post 1183453)
You have some teams that have folded quite a while ago. I see about 5 in ND, but as of last year only 2 were still going.

I'm seeing a problem with this map elsewhere. I know it doesn't really matter because it's one team, but it shows my team located at a Technical Center. Our team moved locations 4 to 5 years ago.

EllaElectrical 29-08-2012 11:26

Re: FRC "Population" Maps
 
Quote:

Originally Posted by jwallace15 (Post 1183506)
I'm seeing a problem with this map elsewhere. I know it doesn't really matter because it's one team, but it shows my team located at a Technical Center. Our team moved locations 4 to 5 years ago.

Yeah, I'm making new maps using the FIRST website instead of blue alliance so hopefully these errors will be eliminated. :)

jwallace15 29-08-2012 11:36

Re: FRC "Population" Maps
 
Quote:

Originally Posted by EllaElectrical (Post 1183507)
Yeah, I'm making new maps using the FIRST website instead of blue alliance so hopefully these errors will be eliminated. :)

Good luck! Post it here when you finish. I want to see the finished product!

JamesC 29-08-2012 14:12

Re: FRC "Population" Maps
 
Quote:

Originally Posted by EllaElectrical (Post 1183507)
Yeah, I'm making new maps using the FIRST website instead of blue alliance so hopefully these errors will be eliminated. :)

I don't suppose you've got a data source hanging around with the locations of the regional/district events too? It'd be interesting to see the spatial organization of teams surrounding event locations...

dodar 29-08-2012 14:18

Re: FRC "Population" Maps
 
Quote:

Originally Posted by JamesC (Post 1183529)
I don't suppose you've got a data source hanging around with the locations of the regional/district events too? It'd be interesting to see the spatial organization of teams surrounding event locations...

Seeing as an event map has been posted on CD so many times I cant even count, all it would take is to just overlay the two maps.

JamesC 29-08-2012 14:19

Re: FRC "Population" Maps
 
Quote:

Originally Posted by dodar (Post 1183530)
Seeing as an event map has been posted on CD so many times I cant even count, all it would take is to just overlay the two maps.

Unfortunately its not quite so easy... I don't want to go through and spreadsheet the locations manually, hence asking for the data source.

EllaElectrical 29-08-2012 17:08

Re: FRC "Population" Maps
 
Quote:

Originally Posted by Mark McLeod (Post 1183429)
I don't think Brooklyn, Queens, Staten Island, or the Bronx count as cities separate from New York City...

On the new map I'm listing them as separate, because no team put New York City, NY, USA as their location.

Mark McLeod 29-08-2012 18:42

Re: FRC "Population" Maps
 
Do whatever is easiest for you.
If we want to stitch together the neighborhoods of New York or LA we can. It'd be hard for an out-of-towner to identify them.
NYC alone has 5 boroughs, 59 community districts, and hundreds of neighborhoods.
LA has 114 neighborhoods.

In all New York city has 39 teams.
Most of the teams listed as "New York, NY" are in Manhattan, but one of them is in Queens. New York City boroughs/neighborhoods listed for teams are Jamaica, Jamaica Estates, Long Island City (L.I.C. too), Fresh Meadows, Forest Hills, Far Rockaway, Flushing, Elmhurst, Bronx, Queens, Queens Village, Staten Island, Brooklyn.

Brandon Zalinsky 06-09-2012 16:08

Re: FRC "Population" Maps
 
:ahh: <- my face when looking at this. This is REALLY cool, I had no idea there was such a concentration around New Orleans.

EllaElectrical 07-09-2012 15:57

Re: FRC "Population" Maps
 
Quote:

Originally Posted by Flak-Bait (Post 1184444)
:ahh: <- my face when looking at this. This is REALLY cool, I had no idea there was such a concentration around New Orleans.

Yeah it's kind of ridiculous and then you look at something like California and although it has 249 teams they're in very concentrated areas.

2348humanplayer 26-02-2013 15:53

Re: FRC "Population" Maps
 
Glad to see ya didn't forget Hawaii.:D

Squillo 26-02-2013 15:57

Re: FRC "Population" Maps
 
2455 is in the wrong place. Honoka'a is on the Big Island, not Ni'ihau! I got all excited, thinking wow, there is a team from Ni'ihau?!?!?! But no, there isn't. No way.


All times are GMT -5. The time now is 17:30.

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