arcGIS Sport development

Question

Hi, I'm trying to find a way to run a sports event through arcGIS. I am confident it is possible, but i need some help coding in the necessary components. Unfortunately I have no coding experience. I work for a London, UK, based charity, LondonYouthRowing.com who provide developmental skills and experiences to young people who'd not normally have access to even the most basic provision, using rowing.  The event is a fundraising event with a community focus. If you're interested or able to help me out, please let me know.

Best wishes

Andy

PS this is my first time using the forum, i apologise if I've broken any rules or such like!

ThomasBall · Answer

I'd try to remove some of the human data entry components by replacing it with GPS units and uploading .gpx files rather than manual data entry.  ESRI lesson plans contain lessons on wildlife tracking. You might need to train rigorous protocols for Start and Stop times for the tracks; but it might make life easier for everyone (yourself as analyst, and the competitors).
Good luck on this, mate. What can be grander than messing about in boats on the Thames?

DavidPike · Answer

My arcgis online knowledge is very limited if I'm honest, but when you get a subscription you'll probably see the way -ahead a bit better.  Hopefully someone else can weigh in for that aspect.

I'm also not sure what database powers an arcgis online (AGOL) hosted feature service, it may be postgres or something proprietary.  In its simplest terms, you would just upload a shapefile to provide the schema really, the rest would be done with http posts to update the spatial database (update each team's location on the river).

I could just generate a series of points with regular spacing along the river, get the geometry(x y locations) of each point, and match it to the distance. it would look something like this:(which you could just match against in a spreadsheet if that's easier for you)

ATHodge · Answer

Hey David

I'm exploring ways to present the race on arcGIS, ideally the story map feature. The use of the dashboard attributes would be important, but i'm hoping i can take elements of these into the story map.

For "the idea about turning the length rowed so far into a coordinate on the river" (thank you for that concise description), can this be done within the arcGIS database or externally on an excel sheet on say google doc's?  It's the bit of arcGIS that seems the most hidden. I visualize an excel sheet database sitting behind the maps - i'm now starting to think it's more of a coding landscape? However the concept you've concisely described is what i intended to do, but is this inside or outside arcGIS?

Could i ask how to move this idea forward? My ambition is to try and have a working prototype for a test event in late Jan.  I've no idea what i'm at liberty to ask of you, so I'm not expecting anything, however if you are able to help put any of the technical bits together, please let me know what you'd need in return. I will have a not for profit subscription to the platform soon.

many thanks

Andrew