The FRC Teams of 2012 (Google Maps)

[John Sabath]

FRC Teams: https://www.google.com/fusiontables/embedviz?viz=MAP&q=select+col2+from+1sr1xNcj1_pHgSCudE03sk2T9X6k5OQ OBkWLFfno&h=false&lat=25.19387279612803&lng=2.1581236250000257&z=2&t=1&l=col2
FTC Teams: https://www.google.com/fusiontables/embedviz?viz=MAP&q=select+col0+from+1L3WxO9sJoWbZEDD9loV8Fu8u-rzxAT1f6T_ggGw&h=false&lat=33.61919376817025&lng=5.692489257812503&z=2&t=1&l=col0

(Unfortunately Google Maps doesn't support overlapping points very well, so you can only see one team from each city)

The raw KML Files:
FRC (https://dl.dropbox.com/u/10285562/Active%20FRC%20Teams%20for%202012.kml)
FTC (https://dl.dropbox.com/u/10285562/Active%20FTC%20Teams%20for%202012.kml)

[jsasaki]

cool stuff

[sanddrag]

Neat. I don't see 696, but I wonder if the dot is in the same place as 589.

[John Sabath]

Neat. I don't see 696, but I wonder if the dot is in the same place as 589.

Yeah, there wasn't much I could do about locations that have multiple teams associated with them.

[SharonO]

I don't see 3528 on the map either. (Kansas City)

[ToddF]

Finally!

I have been dying for a resource like this. I think it's shameful that there isn't a map like this on the USFirst website for FRC, FTC and FLL teams. I've been trying to get my nieces and nephew exposed to FIRST, and having a terrible time figuring out what teams might be closest to them. Thanks so much for putting this together.

[Kristian Calhoun]

Great work, John!

Would you mind sharing the data set/KML you used for this? I've been wanting to create a similar demo using Cesium (http://cesium.agi.com/).

[Libby K]

This is pretty cool to look at. Thanks for making this!

[artdutra04]

Yeah, there wasn't much I could do about locations that have multiple teams associated with them.Was this generated manually or is it database driven?

If the latter, I assume the code is currently displaying the markers on the geographical center of the town/city/area. When displaying the data, have the code check if any other teams are from that same city; if so, add a small offset (a few hundred meters) to the display coordinates.

You could also create a geometric function on where to offset the team markers based upon the number of teams that need to be offset, almost like where the dots are on a pair of dice. If pursuing this option, be sure to leave the function open ended (have it automatically continue creating points), as there are some huge cities (both in population and geographic area) that have a large number of teams.

[Jay O'Donnell]

This is pretty cool! Did you just take a list of current teams and plot them out one by one? I feel like this would take a few weeks at least

[Jibsy]

Finally!

I have been dying for a resource like this. I think it's shameful that there isn't a map like this on the USFirst website for FRC, FTC and FLL teams. I've been trying to get my nieces and nephew exposed to FIRST, and having a terrible time figuring out what teams might be closest to them. Thanks so much for putting this together.

Have you checked out this page?
http://www.usfirst.org/whatsgoingon

Shows all FIRST programs and events, so if they're not at the high school age yet you can still track down some FLL teams.

Yeah, there wasn't much I could do about locations that have multiple teams associated with them.

I suppose it would be a fair bit more work to track down addresses wouldn't it?:rolleyes:
That's unfortunate though... Hides a good 25 teams between Toronto and Mississauga in Ontario. Really cool visualization of the spread of the teams around the world though!

[CalTran]

I don't see 3528 on the map either. (Kansas City)

Sadface. We're not listed either. (Overland Park, KS)

[John Sabath]

Great work, John!

Would you mind sharing the data set/KML you used for this? I've been wanting to create a similar demo using Cesium (http://cesium.agi.com/).

Sure thing. (https://dl.dropbox.com/u/10285562/Active%20FRC%20Teams%20for%202012.kml)

Was this generated manually or is it database driven?
This is pretty cool! Did you just take a list of current teams and plot them out one by one? I feel like this would take a few weeks at least

I parsed this (https://my.usfirst.org/frc/scoring/index.lasso?page=teamlist) into a CSV (Needed city, state, and country to be in the same column) and then imported it into a Google Fusion table.
http://i.imgur.com/kGvX3.png
Google recognizes the last column as geographical data and allows you to visualize it that way.


...I assume the code is currently displaying the markers on the geographical center of the town/city/area. When displaying the data, have the code check if any other teams are from that same city; if so, add a small offset (a few hundred meters) to the display coordinates.


That is correct. Google Earth has the ability to expand overlapping points if you click on them, but unfortunately Google Maps does not. There is a custom Javascript plugin for it that would do the job, but that would require me to have my own hosting option.

[MattC9]

Are there really no teams in South Dakota?

EDIT:
Also most of the Austin area teams are missing

[John Sabath]

Also most of the Austin area teams are missing

They're just overlapping unfortunately.

[dictionaria13]

It's interesting to see where the teams cluster. The Pacific Northwest has a lot more teams than anyone gives us credit for! And it is unfortunate that it only shows one team per city. Still super cool.

[Jibsy]

That is correct. Google Earth has the ability to expand overlapping points if you click on them, but unfortunately Google Maps does not. There is a custom Javascript plugin for it that would do the job, but that would require me to have my own hosting option.

I'm no expert on Google Fusion Tables... how much different is mapping it in Google Earth?

Sounds like a community challenge to track down locations of all FRC teams in a collaborative google doc! :cool:

[1986titans]

This sounds a lot like WITWIF.

http://team1649.com/witwif/

[John Sabath]

I'm no expert on Google Fusion Tables... how much different is mapping it in Google Earth?

Sounds like a community challenge to track down locations of all FRC teams in a collaborative google doc! :cool:

You could simply open the kml file (https://dl.dropbox.com/u/10285562/Active%20FRC%20Teams%20for%202012.kml) with Google Earth.

[n1ckd2012]

Thanks! This will help me find a team near my university!

[Borobo]

poor south dakota. all left out

[HedgeHogGal99]

This map is pretty cool to look at. I find it really neat to look and see where teams are from even if some are missing or overlapping :)

[rachelholladay]

Thanks for sharing this. I've been doing a lot of KML mapping at work (for the Department of Defense) and its interesting to see it put to this use. The formatting of KML is a little strange but it displays very nicely on GE.

It would be interesting to see all the levels of FIRST mapped together (perhaps with FLL is one color, FTC is another, etc.)

[John Sabath]

Thanks for sharing this. I've been doing a lot of KML mapping at work (for the Department of Defense) and its interesting to see it put to this use. The formatting of KML is a little strange but it displays very nicely on GE.

It would be interesting to see all the levels of FIRST mapped together (perhaps with FLL is one color, FTC is another, etc.)

I could dump the KML files for those too if you'd like? Give me a bit; I'll do it right now.

EDIT: The FLL data doesn't seem to be organized very well. Here's FTC though. (https://dl.dropbox.com/u/10285562/Active%20FTC%20Teams%20for%202012.kml)

[Mark McLeod]

Here are more accurate team coordinates for cities/towns with more than one FRC team. These are generally the school locations rather than the city if it's a city with multiple teams. The exception is if a team doesn't list a school affiliation then multiple coords are just offset by a small distance.

http://www.team358.org/files/frc_records/All_FRC_Teams_Ever.xls

[Andrew Schreiber]

If there is interest in seeing distribution data I created http://ewcp.org/blog/2012/01/03/FRC-2012-team-distributions/ a couple months ago (ok, about a week before kickoff). It still displays the multiple teams in one location issue but it shows the number. KML is also available on that site.

[rachelholladay]

I could dump the KML files for those too if you'd like? Give me a bit; I'll do it right now.

EDIT: The FLL data doesn't seem to be organized very well. Here's FTC though. (https://dl.dropbox.com/u/10285562/Active%20FTC%20Teams%20for%202012.kml)

Its interesting that the screentip for the FRC teams is their name but its the location for the FTC teams (or at least is the case on my GE). And actually for me GM is having trouble displaying it at all, perhaps due to size, which wouldn't be the first time. I would assume that Jr. FLL data is no better organized?

[gixxy]

I did this for all the teams in Louisiana at one point. It I find the map link I will post it when I get to a real computer. (I did it manually based on school location from the FIRST search.)

[ETGrant1649]

This sounds a lot like WITWIF.

http://team1649.com/witwif/

Naw... WITWIF is better ;-) OK maybe I'm Partial.

[ETGrant1649]

This sounds a lot like WITWIF.

http://team1649.com/witwif/

Just updated WITWIF to include the latest data from FIRST... Also made a special version for FLL USA events. FLL teams not available.

Added ability to link directly to an event... still working on the UI to get the link.

Check it out... http://team1649.com/witwif