pic: FRC Teams Map

[Steven Smith]

Another idea that might be a little fun as you are playing around with it... would be to identify what the breakpoints are on team numbers for each year (or use an alternate method). Then make an animated GIF that shows the distribution of teams by year and how FIRST has spread to new areas and increased in density in existing areas.

Just playing off a previous comment

Good luck with this, I will keep checking in on it from time to time. It is a great way of showing the students how big FIRST has become and how much it can still grow..

[who716]

how come there aren't any teams in Antarctica?

[madhav]

Just took a look at Google Fusion Tables, and it's api seems perfect for scouting apps. You could overlay data on a field map.

Are there any teams that already use this for this function?

[evanperryg]

Originally Posted by madhav

Just took a look at Google Fusion Tables, and it's api seems perfect for scouting apps. You could overlay data on a field map.

Are there any teams that already use this for this function?

I started working on using Fusion to process scouting data, but abandoned it because you can create a better setup with a fluency in Excel commands. It's clear that Fusion is either still in its early stages, or has been neglected by Google. It has a lot of potential, but it seriously lacks some valuable features.

[Joe Ross]

Originally Posted by Steven Smith

Another idea that might be a little fun as you are playing around with it... would be to identify what the breakpoints are on team numbers for each year (or use an alternate method). Then make an animated GIF that shows the distribution of teams by year and how FIRST has spread to new areas and increased in density in existing areas.

How about this? http://www.team358.org/files/frc_rec...-1992-2012.pdf

[nathannfm]

Originally Posted by Joe Ross

How about this? http://www.team358.org/files/frc_rec...-1992-2012.pdf

I knew I couldn't have been the first one to have done this

[Andrew Schreiber]

Originally Posted by nathannfm

I knew I couldn't have been the first one to have done this

Along the same lines only more interactive: https://public.tableausoftware.com/v...splay_count=no

[Navid Shafa]

What percent ambiguity did you get when Fusion did batch Geocoding of teams?

[nathannfm]

Originally Posted by Navid Shafa

What percent ambiguity did you get when Fusion did batch Geocoding of teams?

It was hovering around 3% I think, I didn't watch it the entire time, it took forever. I am guessing percent ambiguity is locations it can't figure out?

[Navid Shafa]

Originally Posted by nathannfm

It was hovering around 3% I think, I didn't watch it the entire time, it took forever. I am guessing percent ambiguity is locations it can't figure out?

Yes, percent ambiguity is the quantity of locations that it was unsure about and has a high chance of showing an incorrect location.

Processing all the locations does take a while, if you have access to the lat./long. coordinates, it will process match faster as it doesn't have to cross reference each cell.

[Mark McLeod]

If you want them, actual team lat/lon's are in here: http://www.team358.org/files/frc_rec...Teams_Ever.xls

These coords are based on the primary school or sponsor locations and avoid the overlapping team problem as well as geocoding errors.
One tab is a list of all teams ever, while another tab are the teams for each season.