FRC "Population" Maps

[EricH]

Originally Posted by Mark McLeod

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]

Originally Posted by EricH

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]

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]

Originally Posted by 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.

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]

Originally Posted by 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.

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

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]

Originally Posted by Jon Stratis

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]

Originally Posted by 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/7a90e9236610...640cbca7d36d9d

Originally Posted by 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.

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]

Originally Posted by jwallace15

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]

Originally Posted by EllaElectrical

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]

Originally Posted by EllaElectrical

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]

Originally Posted by JamesC

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.