Chief Delphi

Chief Delphi (http://www.chiefdelphi.com/forums/index.php)
-   General Forum (http://www.chiefdelphi.com/forums/forumdisplay.php?f=16)
-   -   The FRC Teams of 2012 (Google Maps) (http://www.chiefdelphi.com/forums/showthread.php?t=107191)

John Sabath 06-07-2012 02:22

The FRC Teams of 2012 (Google Maps)
 
FRC Teams: https://www.google.com/fusiontables/...z=2&t=1&l=col2
FTC Teams: https://www.google.com/fusiontables/...z=2&t=1&l=col0

(Unfortunately Google Maps doesn't support overlapping points very well, so you can only see one team from each city)

The raw KML Files:
FRC
FTC

jsasaki 06-07-2012 02:40

Re: The FRC Teams of 2012 (Google Maps)
 
cool stuff

sanddrag 06-07-2012 03:06

Re: The FRC Teams of 2012 (Google Maps)
 
Neat. I don't see 696, but I wonder if the dot is in the same place as 589.

John Sabath 06-07-2012 03:12

Re: The FRC Teams of 2012 (Google Maps)
 
Quote:

Originally Posted by sanddrag (Post 1176338)
Neat. I don't see 696, but I wonder if the dot is in the same place as 589.

Yeah, there wasn't much I could do about locations that have multiple teams associated with them.

SharonO 06-07-2012 08:07

Re: The FRC Teams of 2012 (Google Maps)
 
I don't see 3528 on the map either. (Kansas City)

ToddF 06-07-2012 09:07

Re: The FRC Teams of 2012 (Google Maps)
 
Finally!

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.

Kristian Calhoun 06-07-2012 10:39

Re: The FRC Teams of 2012 (Google Maps)
 
Great work, John!

Would you mind sharing the data set/KML you used for this? I've been wanting to create a similar demo using Cesium.

Libby K 06-07-2012 11:50

Re: The FRC Teams of 2012 (Google Maps)
 
This is pretty cool to look at. Thanks for making this!

artdutra04 06-07-2012 11:53

Re: The FRC Teams of 2012 (Google Maps)
 
Quote:

Originally Posted by John Sabath (Post 1176339)
Yeah, there wasn't much I could do about locations that have multiple teams associated with them.

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.

Jay O'Donnell 06-07-2012 11:54

Re: The FRC Teams of 2012 (Google Maps)
 
This is pretty cool! Did you just take a list of current teams and plot them out one by one? I feel like this would take a few weeks at least

Jibsy 06-07-2012 11:57

Re: The FRC Teams of 2012 (Google Maps)
 
Quote:

Originally Posted by ToddF (Post 1176353)
Finally!

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.

Have you checked out this page?
http://www.usfirst.org/whatsgoingon

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.

Quote:

Originally Posted by John Sabath (Post 1176339)
Yeah, there wasn't much I could do about locations that have multiple teams associated with them.

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!

CalTran 06-07-2012 12:26

Re: The FRC Teams of 2012 (Google Maps)
 
Quote:

Originally Posted by SharonO (Post 1176351)
I don't see 3528 on the map either. (Kansas City)

Sadface. We're not listed either. (Overland Park, KS)

John Sabath 06-07-2012 12:38

Re: The FRC Teams of 2012 (Google Maps)
 
Quote:

Originally Posted by Kristian Calhoun (Post 1176361)
Great work, John!

Would you mind sharing the data set/KML you used for this? I've been wanting to create a similar demo using Cesium.

Sure thing.

Quote:

Originally Posted by artdutra04 (Post 1176367)
Was this generated manually or is it database driven?

Quote:

Originally Posted by Jay Money 1058 (Post 1176368)
This is pretty cool! Did you just take a list of current teams and plot them out one by one? I feel like this would take a few weeks at least

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.

Quote:

Originally Posted by artdutra04 (Post 1176367)
...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.

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.

MattC9 06-07-2012 12:40

Re: The FRC Teams of 2012 (Google Maps)
 
Are there really no teams in South Dakota?

EDIT:
Also most of the Austin area teams are missing

John Sabath 06-07-2012 12:44

Re: The FRC Teams of 2012 (Google Maps)
 
Quote:

Originally Posted by MattC9 (Post 1176376)
Also most of the Austin area teams are missing

They're just overlapping unfortunately.


All times are GMT -5. The time now is 02:45.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright © Chief Delphi