How I made this: First, I used the TBA API to get a list of all of the teams and the years they were active. I decided to restrict myself to active teams, meaning those participating in 2017. Once I had my list of active teams, I used the Nominatim OpenStreetMap API to get representative latitude-longitude coordinates for each team’s location. By representative, I mean that they are in the city listed as the team’s location. They are not the actual locations, so don’t use this for navigational purposes.
There are about 30 teams (mostly Israeli) still missing; this is due to Nominatim not understanding the location data from TBA. I am adding those coordinates by hand, and they should be up shortly.
Almost want to have a map of teams that are now defunct, ideally with a tag for the reason they stopped.
Team attrition makes me sad, I wish there was more I could do to help prevent it. I’ve always thought that keeping existing teams is far more important than starting new teams.
Since TBA has as accurate as a history as you are going to get on most FRC teams these mapping applications could probably be modified to drop two sets of colored pins, one for teams that are no longer active as of 2017 and another color for ones that are.
Tags on why teams stopped would have to all be manual. Sadly it wouldn’t be hard, just alternate listing “lost lead coach/mentor” and “lost main sponsor” every other team and you’ll get at least half of them correct . Looking at old team lists from Arizona every team that I knew well and folded was due to one of those causes.
I think Jim Zondag has a wealth of information on defunct teams. I believe much of it has to do with money after their rookie year and post-NASA funding.
I’m wondering if there’s a way you could allow teams to edit and add their exact location. This would avoid the problem a few readers have had, where there are multiple teams in one town so they only see one, giving the impression that the other teams are missing. I’m not sure how you could do that while preventing bad locations from being added, so I’m just giving an idea here.