pic: Michigan Team Growth 2009-2016
 

Re: pic: Michigan Team Growth 2009-2016
 

This is awesome thanks for sharing! It's always cool to see how FIRST spreads and impacts others.

Re: pic: Michigan Team Growth 2009-2016
 

Here's the same map (but without the team count) as a gif:

Re: pic: Michigan Team Growth 2009-2016
 

Very cool graphic.

A similar graphic showing events over time would be neat to see too. This past year, I helped support 6 District events, and they were all within about a 1 hour drive from home... (Southfield, Kettering 2, Centerline, Marysville, Troy, Ann Arbor). This is really quite crazy when you think about it from a growth and coverage standpoint. Even crazier, there were still several other events within an hour from home (Kettering 1, Howell, Waterford...).

Re: pic: Michigan Team Growth 2009-2016
 

This really shows how FiM hasn't just increased school participation in the southeast side of the state, where the majority of Michigan teams used to exist. But how the west side of the state has developed into pretty much its own district. Also the northern part of the LP and the UP itself has grown a ton.

Re: pic: Michigan Team Growth 2009-2016
 

Awesome visual!

I hate to be "that" guy, but the maps for 14-16 are labeled 10-12.

Re: pic: Michigan Team Growth 2009-2016
 

I never realized how huge some of the zip codes in the UP are.

Re: pic: Michigan Team Growth 2009-2016
 

I can't believe I didn't notice that...

I'm not sure if I can edit the original image, but here's a fixed version of it. Thanks for pointing that out and sorry about that.



I haven't figured out how to overlay these two maps, but here's a gif of events over time:

(sorry, I can't figure out how to shrink this and still have it move)

Also, I think the zip code for the DCMP location in 2015-16 is off. It says it's 48544 but that's somewhere in Svydova according to google. I used 49544 (from DeltaPlex Arena's address). I'm not sure if this affected other districts, but if you notice something else is wrong let me know and I'll manually change the zip code.

Re: pic: Michigan Team Growth 2009-2016
 

You must spread some Reputation around before giving it to Rachel Lim again.

Actually, though, if you started a blog dedicated to FRC data analysis, I would love it!

Re: pic: Michigan Team Growth 2009-2016
 

What did you use to create these graphs and the gif? I recently used Google sheets and the map marker for Texas, but didn't find it to be too user friendly.

Re: pic: Michigan Team Growth 2009-2016
 

This is really cool. What did you use to make it?

Re: pic: Michigan Team Growth 2009-2016
 

I'm trying to come up with something focused on CA competitions (specifically norcal since I'm not sure how much time I'll have), but I may expand it later on. Look out for something (hopefully) soon! :)

Tableau for the graphs and Excel storing/formatting the data. I found it to be the most intuitive way to deal with any sort of location-type data. I haven't found a way to tell it which state cities are in though, so I have to link city data to zip codes and map that. Once that's done though, I really like it because I can give it a list of locations per year and create either multiple columns of maps, or pages that it can loop through (the gifs are screenshots of that).

If you'd like more details or have any other questions let me know--I'm happy to go into more specifics if you'd like.

Re: pic: Michigan Team Growth 2009-2016
 

Where did you get the data from?

Re: pic: Michigan Team Growth 2009-2016
 

Team lists: the "what events and teams are in my area?" searches (e.g. this is Michigan for 2016)
https://my.usfirst.org/myarea/index....16&area=mi-usa or http://frclinks.frclinks.com/t/mi-usa/2016

Event lists: TBA API, district events request
http://www.thebluealliance.com/apidocs

Zip codes: combined the two below
http://www.unitedstateszipcodes.org/mi/
http://www.zipcodestogo.com/Michigan/

I think there are ways to automate this further (certainly actually using the API as opposed to copy/pasting data out would help), but I've found this to be enough for what I need it for.