2016 Michigan Teams by County

[cbale2000]

Originally Posted by Ed Law

Attachment 21009
This is the most up-to-date 2016 team numbers by county. It also shows where the district events were. The nice thing about this map is it is linked to the official FiM master team spreadsheet. It will be a lot easier to update the map in the future.

Out of curiosity, is this sort of data available going back a few years? I'd be interested in seeing if an animated graphic could be made that would show the growth of teams over time by area as this does.

[Christopher149]

Originally Posted by cbale2000

Out of curiosity, is this sort of data available going back a few years? I'd be interested in seeing if an animated graphic could be made that would show the growth of teams over time by area as this does.

Unfortunately the map keeps changing, and it doesn't look like there is a 2015 map (but http://frclinks.frclinks.com/t/MI-USA/2015 has location info). But here are:

• 2011
• 2012
• 2013
• 2014
• 2016

[orangelight]

I made a Michigan team map using the data from the First website that shows which events teams go to without the state championship. Some of the team location data doesn't seem to be correct (They are in a lake).

[jnicho15]

Originally Posted by orangelight

I made a Michigan team map using the data from the First website that shows which events teams go to without the state championship. Some of the team location data doesn't seem to be correct (They are in a lake).
Attachment 21010

The team in Lake Michigan looks to be this one from Beaver Island.

[Richard Wallace]

Great work, Ed!

Looks like Kalamazoo Central HS would be a good location for a new district sometime soon, based solely on geographic distribution of teams. 6002 ZooBOTix started there this past season, but I don't see any CD accounts with that team number. Anyone here know someone on that team?

[Christopher149]

Originally Posted by jnicho15

The team in Lake Michigan looks to be this one from Beaver Island.

One in Lake Huron is from Mackinac Island, and the other does seem to have a slightly incorrect location (they belong a touch further north).

[Ed Law]

Originally Posted by orangelight

I made a Michigan team map using the data from the First website that shows which events teams go to without the state championship. Some of the team location data doesn't seem to be correct (They are in a lake).
Attachment 21010

I am curious exactly where you get the team location data from.

[orangelight]

Originally Posted by Ed Law

I am curious exactly where you get the team location data from.

The firstinspires.org team and event search page returns lots of values about the team including the lat and lon. http://es01.usfirst.org/teams/_search

I'll see if I can find my Michigan team data set
EDIT: Here http://pastebin.com/HVeY9KJh