Hi David, thanks for the quick reply. by way of a quick summary of what i'm trying to do and achieve. The event is for say 100 teams. In each team is 8 participants. The teams are racing over a virtual river Thames, UK, 346km. The participants will contribute to the team mileage using indoor machines, rowing, running, cycling, arm bike, ski erg etc (anything with an electronic output.). They will have a week to complete the challenge. As they input their data i'd like to represent this on an online map - ie arcGIS!
So to do this i believe i'm looking at 4 stages, however where arcGIS comes into the picture is what i'm trying to work out, and therefore what help i need!
1) data input - the participants upload their individual data. This we can do through an ESRI survey form or a google form. I also have a friend who's written some python scrip that can pull data submitted through twitter, and thinks he can do the same for Instagram (which i'm very excited about)
2) database - here we need to collate the data into the teams to produce a team's total mileage. this can be done on google doc's and i believe should be possible in arcGIS, but requires coding?
3) output - If arcGIS can do what i believe it can this stage is skipped - or - an excel sheet matches the distance of the team to a specific coordinate along the virtual river that we've created beforehand, and returns the list of teams and their coordinates to upload to a map.
4) within arcGIS, can we create a line along the map which knows how long it is and can directly plot crew markers along that line based on the distance achieved - or - we upload a CSV file of coordinates matched to teams to display the distances achieved. I know this can be done on Google MyMaps, but it won't look very good.
If any of this can be achieved with arcGIS I'd then like to add further information about the companies involved, the charities involved, where participants are based etc. All this is static data so can sit in the background. However if i can link the funds raised to the giving platform api, it would be great to have a running total.
With all of this in place than i can build a story map that presents the event in a way not seen before. Adding social media feeds, video inputs, and if it could work a zoom feed directly onto the story map.
I think there is a simply way but requires manual uploading of data and is clunky, or a complicated heavy coding way, that could automate the whole lot that would be slick. Your thoughts on this and what it would take would be greatly appreciated. And sorry if it's not what you thought it might be!
Kind regards
Andy
