[FRC Blog] FRC Events Being Posted and AMAA on FUN

[ahartnet]

Originally Posted by rwodonnell

Yes. Unfortunately, the data from TBA that was easy for me only has city and state. When I imported them into the map, it stacks teams from the same city. If you click on the down arrow below the "teams.csv" layer, it will list all the teams that have a dot there. Cities like Middletown and Waterbury (from the teams you mentioned) and of course Boston (6 teams), Worcester (4 teams) and others will look like they just have one dot.

This does have the effect of improperly showing less team density in certain areas. If I could figure out how to have it put a number on those, or change the size of the dot, I would. If anyone has a CSV file of the teams in NE that includes a street address, I will import that and that should fix the problem, save for teams with the exact same street address (if there are any).

If you put the data in google sheets, you can do the map marker and you'll have bubbles sized to the # of teams there. I recently downloaded Tableau (that's what the person who did the map for Michigan team density did and it looked great) to do the same there though, because with the google sheets map, it's "smallest" size is the continental US. Which is workable for mapping teams in Texas. probably not so much so NE. *EDIT* - here's a link to my google sheet for reference: https://docs.google.com/spreadsheets...5mQ/edit#gid=0 - it takes a long time to load because it basically does a search for every one of the cities