FRC "Population" Maps

[EllaElectrical]

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/ccc?key=0AofhxxUtI6aNdGZoYUVmT09fVTN0bmdCOVhkTHhHW Wc#gid=5

[Wayne TenBrink]

Very cool. Thanks for putting this together.

I am struck by the difference between Minnesota and Iowa.

[jwallace15]

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]

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]

You should try to make one that does the states by percentage of schools covered.

[MARS_James]

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]

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]

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]

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]

Awesome numbers!

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]

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]

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]

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

[Racer26]

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!

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.lasso?page=searchresults&omit_searchform=1&skip_teams=750&-session=myarea:C77D64051437c27563WWUU3C9A2E#FRC_te ams)

[Mark McLeod]

I don't think Brooklyn, Queens, Staten Island, or the Bronx count as cities separate from New York City...

[EricH]

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]

Which highlights the one major problem with the FIRST website location column...
...Which is why Mark at 358 (http://www.team358.org/files/frc_records/) 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 (http://www.team358.org/files/frc_records/All_FRC_Teams_Ever.xls) (XLS link) spreadsheet. He's got just over 20% of them now.

[Jon Stratis]

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]

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]

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]

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]

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/7a90e92366106f9267640cbca7d36d9d

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]

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]

Cool, but the total team count seems low.

[Racer26]

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]

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/7a90e92366106f9267640cbca7d36d9d

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]

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]

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]

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]

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]

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]

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]

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]

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

[EllaElectrical]

: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]

Glad to see ya didn't forget Hawaii.:D

[Squillo]

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.