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.
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.
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.
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!
I parsed this into a CSV (Needed city, state, and country to be in the same column) and then imported it into a Google Fusion table.
Google recognizes the last column as geographical data and allows you to visualize it that way.
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.
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.