pic: Average Travel Distance for FRC Teams to US


#1



This is an interactive viz that shows the average travel distance for FRC teams to all the counties in the US. I thought it would be interesting to see where the championship would be if the only consideration was average travel distance. Distances were calculated as the crow flies for simplicity. I also looked at just USA teams, just the Detroit and Houston Teams, and just the international teams.

Credit to 1418 and https://github.com/FIRSTMap/firstmap.github.io for the lat/long of each team.

Tableau viz: https://public.tableau.com/views/AverageTravelDistanceForEveryTeam/AllTeams?:embed=y&:display_count=yes&publish=yes


#2

So, the center of the FRC world is Kalamazoo? Who knew?

I mean, besides 2767?


#3

What about if you limited it just to teams who attended champs last year? Maybe it would make Michigan teams pull things a little less (though on second thought maybe not?)


#4

When I click on South Teams it seams to center on Colorado…


#5

I added three new sheets that do as you suggested, didn’t make much of a notable difference.

Correct, so for all the teams who go to the southern championship, they are traveling an average of 2036 mi (Harris County TX) as opposed to the minimum average distance possible which is somewhere in Colorado (~1900 mi).


#6

Denver champs? Ill sign up real quick for that.


#7

Interesting that the South Champs has such a small automatic mileage spread on the color scale. It looks like there is a pretty wide swath of the West and South that can be chosen for South Champs with very minimal travel mileage impact.


#8

I wonder how **deep **you would have to put south champs to minimize the straight-line distances.:]


#9

Haha. Me too.
I guess my conceptual issue was I was thinking of distance from counties, with counties being weighed evenly… not by teams that actually exist in those counties. Explains why Alaska didn’t pull South Champs into Oregon.


#10

This is probably because of the large international presence at South Champs. A South Champs (USA only) would probably be more relevant).


#11

Yikes, what happened to Oglala Lakota County (Shannon County) in SD? Were county seats used as an endpoint to calculate distance? This is the only explanation I can think of (Oglala Lakota County is the only county in the US (that I know of) to have its county seat outside of the county).

Is it possible to recalculate the distances as Manhattan distance? Then average the Euclidean and Manhattan? I have a feeling that will give a much closer representation of real-world travel distances. (Whether or not it is actually useful is another matter entirely.)

If I had the free time I would dive into this: https://stackoverflow.com/questions/17267807/python-google-maps-driving-time Select maybe 2 dozen candidate cities vs the team subset and let it go to town (no pun intended). Pick the city with the lowest residuals, boom. (It might hic-up where no road network is present (i.e. Hawaii)).

Also a quick cartographic tip to the OP (not trying to be mean), since you are dealing with difference and not a variance (i.e. positive only values) you should be using a monochromatic color scheme. The current color you are using is really only commonly applicable to +/- situations, such as standard deviation. The point I am trying to make is the eye is drawn to the ring of low saturation hues, and not to the point of your map: the geographic center of a distribution.
While the map is easy enough to read, the color scheme adds complexity where there doesn’t need to be any.


#12

It would be interesting to optimize on multiple sites (an arbitrary number from n=2-100) minimizing distance from the closest site for all the teams.

And also interesting to redo that calculating driving distances (e.g. Google Maps API).

You could also add a constraint about how many teams can go to the site, so you wouldn’t have a bunch be at a single site.


#13

I may or may not have decided I need to play with this right now…


#14

Belle Fourche, South Dakota

All they need is a big building, a bunch of motels, and a big parking lot, but it’s the fairest.


#15

From a realistic standpoint of actual travel distance, proximity to a major international airport is key, ESPECIALLY for south champs. By major, I mean one where international flights come in from many directions.


#16

Yes, it looks like the South Champs could be in California just as easily as Houston with little impact on travel distance. Los Angeles is 2,041 miles versus 2,028 for Harris County.


#17

The endpoints for the counties were the coordinates to the approximate center of the county, taken from here. But I’m not really sure why Oglala county is not showing up.

This map would definitely be more interesting if each distance was calculated using the Google Maps API, and I looked into it, but it was a bit over my head. Someone else can give it a shot though! Thanks for the note about the color scheme, that makes a lot of sense. The single color gradient looks much better.


#18

Time to have worlds entirely within 2767’s lab.


#19

So the problem with google is you will end up paying for more than n accesses of the api per day. It’s not stupid expensive, but still I don’t have $100 to test all teams vs 24 unique cities (even if I used a geographically weighted subset of a few hundred teams). The key thing is travel duration. This might be possible through open street maps as well. I can toss the kinda-sorta-working python script on github if anyone is interested.

I might also be able to use arcmap’s network features. But the google approach seemed way easier at the time (untill I found out about the cap).

Another interesting result may be: instead of modeling distance as a linear relationship, model it as a nth degree polynomial. This way you could fit drivetime cost based on time of day leaving (i.e. preferance to not arriving to a hotel at 5am) I can elaborate more if anyone is interested.


#20

If we do, would we need to ship our robot still?