Open harrislapiroff opened 10 years ago
Charts and graphs! We could probably cache the distance on the row rather than re-computing it each time.
I think for now we should just offer charts of where folks hail from. Later on we an add the data described here.
I wanna make maps!
So I thought this would be a lotta work, but it turns out if we can get the lat/long of cities where folks are coming from, we can use math to calculate distance. i.e. we don't need to have a Geo DB of the entire country, which is what I had thought we'd need. :-p
There are geocoder services that do that (usually free up to a limit, then pay per request) but they could also easily take addresses and do it for more precision. If we don't wanna pay for a geocoder service, there are freely available databases that map US zip codes to long/lat coords.
Let's offer geographic data to organizers. Mean/median distance of attendees, distance for each row, maybe even maps of attendee locations for ease of ride coordination?