Facebook

Login

Support Sailonline

If you haven't already - join the SAILONLINE YACHT CLUB!

Please also consider making a donation - all amounts are greatly appreciated!

Board » General Discussion » My SOL race history site

Page: 1 2 Next

As some of you have already seen in the race chats, I have created a small website for SOL race history data.

I have basically saved boat position information from SOL races every hour and then display this data with some additional calculated numbers per update or boat.

The data is accessible at http://sol.hmm.iki.fi/sollog/races/

I first started collecting this data and building the site just for my own purposes but it has now probably reached a state where it's useful and usable for others as well.

The site is still very much under development and the updates don't happen automatically so don't expect it always have the latest information.

My next steps will be making the updating automatic and making the quite crude site layout a bit more nice looking and easier to use.

I have also in my mind quite a lot of new features for the site but you are welcome to suggest things in this thread. Just keep in mind that this project is mostly for my own fun.

If anyone is interested to use the raw data I collect from sol to some other purpose (like building a race history player or show them in google maps etc) I can probably quite easily provide a rest/json or similar api for the data if desired.

So far I plan to store data from all SOL races in the future but that can change if the amount of data proves to be too much for my server.

BTW, if any of the SOL administrators think that it is improper for me to use data from the server like this, please let me know.
Would be possible to add TWA, TWS?
Thank you,
Antonio

--- Last Edited by zero at 2012-01-28 17:19:08 ---
TWA would be useful to show when and how long we hit land and how long we sailed dead up wind when we left the boat on CC during extend period of time.

Great stuff.
Thanks again.

Antonio
Unfortunately TWA is not yet available as SOL server gives TWA/TWD/TWS etc wind information only to your own boat, not the whole fleet.

I plan to add storing weather information later and then it's possible to calculate TWA etc. for each boat. When it's available, I'll probably include it in the tables as well.

However, even now you can see if you're grounded from the distance traveled. If that's 0 then you're either grounded, TWA is zero or it's dead calm.
Could the Lat and Long of own boat be included on the own boat page? It's on the whole fleet page for each time, but if you want to re-construct your own course it would take a lot of work.
If it breaks, it's not strong enough--if it doesn't, it's too heavy.
Yes, the coordinates can easily be added to the boat position history. Will do that in near future.

Would there be demand of CSV (for excel import) or json versions of the tables? It would be pretty easy to have http://sol.hmm.iki.fi/sollog/boat/hmm/282.csv which would have basically the same data as comma separated values which then could be imported to excel.
This is AWESOME!!

Well Done!

SP
For anyone interested, I have now added simple comparison of two boats (on a boat's detail view, type the name of the boat to compare and push the compare button).

And probably more interesting to people is now displaying the boat routes in google maps. I.e. see the winners route on Leg 3 here: Exmeromotu

The logical next steps will probably be adding comparison of routes on maps and perhaps having fleet positions on map per update.
Regarding the map view, which is great - what I would suggest is to grab data a little more often (even use a time interval based on race length?), and filter out those which have the same heading (or within some limit like 1° or something). Updating hourly, you will often miss those short tacks (or gybes) the winner & top finishers make which are critical to how they won. And that would also stop some of the corners being chopped off in the shorter races (which SOL does more of). Also remember to make the first point on the map (or the last depending on how you draw the route) the Start of the race, like here

(PS I like it that the rest of the site has no extensions in its URLs - perhaps do the same for map?)

Awesome work though, this is really becoming useful to a wider SOL group - not an easy thing to do!! ;-)




--- Last Edited by Aaron Gage at 2012-02-10 03:02:43 ---
I help develop the client interface for the best online ocean racing sim there is... __/)/)_/)__
For some reason when I click on the link, the map shows but not the tracks.
What am I doing wrong?

Page: 1 2 Next

Please login to post a reply.

Races

Next Race: 00d 00h 00m


Current Races:

Newport to Annapolis 2025


The Newport to Annapolis race, first held in 1947, is one of the most historic and well-known US East Coast blue water races. Linking two seaports dating from the US nation's birth, Annapolis and Newport, the race contrasts the country's largest estuary, the Chesapeake Bay, and the Atlantic Ocean. Since 1969, the route has run from Annapolis through the Chesapeake Bay to Newport. The SOLers will sail 470nm in their Carkeek40s in the original direction from Newport to Annapolis, including the Chesapeake, which is such a daunting challenge that the 1997–98 Whitbread Round the World Race for the Volvo Trophy added it to the course, as did the Volvo Ocean Race in 2002 and 2006.
Race #1912
INFO from brainaid.de
Carkeek 40 PARTICULARS
WX Updates:
0245 / 0845 / 1445 / 2045
Ranking:
ARQ2 - ARCH - SUPSOL – SYC
Race starts: May 12th 17:00 Registration Open!
▶ Flash
GO TO RACE

Channel Islands TIMED Chase 2025

Join us in Saint Peter Port, Guernsey for a race around the Channel Islands in the J-109, a recent addition to the Sailonline fleet. The course takes us around the islands of Alderney and Jersey finishing back in Saint Peter Port. This is a TIMED race, so you may RE-REGISTER HERE to try again, after finishing a run. You will have 13 days and 11 hours to test your skill and decision making after the race opens.
Race #1915
INFO by brainaid.de
J-109 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking:
TRQ2 - TRCH - SUPSOL - SYC
RACE CLOSE: Saturday,
24 May at 23:00 UTC
Race starts: May 11th 12:00 Registration will open soon
▶ Flash
GO TO RACE

Elephant Island to Marquesas 2025

Prepare to test your limits as we launch into the third leg of the RWW Series and the fifth leg of the 2025 Ocean Championship Series—an epic voyage from Elephant Island to the Marquesas in the heart of French Polynesia. This 4,700-nautical-mile challenge is a true test of endurance, strategy, and raw sailing adrenaline. Aboard the high-performance Volvo 70v4, competitors will face fierce headwinds as they round the legendary Cape Horn and make the thrilling transition from the Atlantic to the Pacific. Do you have what it takes to conquer the Pacific? Join us, and put your skills to the ultimate test.
PRIZE: SMPF
Race #1909
INFO by brainaid.de
VO70_v4 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: OCQ2 - RWW - OCCH - SUPSOL - SYC
Race starts: May 05th 11:00 Registration Open!
▶ Flash
GO TO RACE

Transat à Deux 2025

Above you see a single-handed sailor semi-foiling his Beneteau Figaro III to the horizon. It is in fact Ireland’s Sailor of the Year and the overall winner of last year’s Solitaire du Figaro, Tom Dolan. Somehow, we got our hands on a polar for the Class, and rather than trying to surreptitiously track Tom and his mates in the 2025 edition of the Solitaire, sailing rather-short, single-handed legs across the Celtic Sea and Biscay, we thought we’d see how our virtual craft would fare on the Class’s double-handed 3900nm Trans-Atlantic, from somewhere in Brittanny to somewhere in the Caribbean via somewhere in the Canaries. Allez, mes braves!
Race #1901
INFOby brainaid.de
Figaro III foil PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: SYC
RACE CLOSE: Thursday,
May 15 at 2300 UTC.
Race starts: Apr 20th 11:00 Registration Closed
▶ Flash
GO TO RACE

Sinbad by Balloon 2025 - Toamasina to Baia de l'Oiseau


You may recall that when last we visited Madagascar in the company of Sinbad, the Sultan commanded our intrepid inspirator to seek out fabled islands where in Summer the sun barely set. We did and we returned but the Sultan wasn’t happy with Sinbad’s report, so here we go again, now by SOL Balloon instead of sailing vessel. Expect to be in the air for at least 2100nm and depending on how the wind brings us, anything between two weeks and two months before we shall descend at the Sultan’s given coordinates!
Race #1884
INFOby brainaid.de
SOL Balloon PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: SYC - SBB
RACE CLOSE: Sunday,
May 18 at 2300 UTC.
Race starts: Apr 09th 11:00 Registration Closed
▶ Flash
GO TO RACE

Go to race archive

SYC Ranking

  1. Sailonline Yacht Club Member WRmirekd
  2. Sailonline Yacht Club Member Patrick70119
  3. Sailonline Yacht Club Member CriticalHippo
  4. Sailonline Yacht Club Member KaSToR
  5. Sailonline Yacht Club Member FreyjaUSA
  6. Sailonline Yacht Club Member rafa
  7. Sailonline Yacht Club Member Kipper1258
  8. Sailonline Yacht Club Member vida
  9. Sailonline Yacht Club Member bonknhoot
  10. Sailonline Yacht Club Member rumskib

View full list

Series

Mobile Client

SYC members have the benefit of access to our mobile/lightweight web client!

The mobile client