Automate data updates from TBA

[andrewda]

It'd be pretty easy to run the data gathering scripts from Travis CI on a timer and then push the results if there's a difference.

[GeeII]

Perhaps for the event data, but unfortunately the team lookups for latitude and longitude are rather brittle, especially when there is no zip code in the data from FIRST. As I can, I'm regularizing them, but a significant fraction of new teams (about one in five for the 2019 rookies) require manual intervention.

[EthShaw]

The event data could be loaded directly from The Blue Alliance and cached locally in the browser in an Indexed Database (or localStorage). I am willing to take a stab at it and then make a pull request.

[ErikBoesen]

@FishDog5000 We thought about it but that's extremely slow and doesn't account for locations as far as I'm aware. Feel free to try if you want.

[GeeII]

Repeating what I said earlier: the hard part of doing this is converting the zip-postal-code [when available[/city/state-province/country and possibly the sponsor info for each team in to a latitude and longitude - the geographic location does not come from TBA or FIRST, but must be calculated somehow.

[EthShaw]

Now that TBA no longer includes geolocation directly with events, I've been thinking about ways to automate scraping of event locations. I've done some experiments, and the OpenCage API seems to work pretty well for resolving most event addresses (only a few were missed).

I am thinking I might be able to create a Github Action that auto-runs the team avatar scraper and possibly pull locations for events and teams that it can find every few weeks. Then a user could manually intervene and add missing event / team locations every so often. This wouldn't completely solve the problem of required manual work, but could make some things update a little quicker than "when I have time and remember to pull team/avatar/event updates."