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

Posted by
hmm


Users avatar

Posts
118
Registered at
2011-11-03 13:35:22
2012-01-28 12:59:44 - My SOL race history site
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.
Posted by
zero


Users avatar

Posts
120
Registered at
2010-02-07 16:56:30
2012-01-28 17:16:16 - Re: My SOL race history site
Would be possible to add TWA, TWS?
Thank you,
Antonio

--- Last Edited by zero at 2012-01-28 17:19:08 ---
Posted by
zero


Users avatar

Posts
120
Registered at
2010-02-07 16:56:30
2012-01-28 17:36:40 - Re: My SOL race history site
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
Posted by
hmm


Users avatar

Posts
118
Registered at
2011-11-03 13:35:22
2012-01-28 17:51:26 - Re: My SOL race history site
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.
Posted by
Rod


Users avatar

Posts
392
Registered at
2010-06-24 22:30:48
2012-01-28 23:16:12 - Re: My SOL race history site
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.
Posted by
hmm


Users avatar

Posts
118
Registered at
2011-11-03 13:35:22
2012-01-29 20:42:33 - Re: My SOL race history site
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.
Posted by
ShamrockPirate


Users avatar

Posts
189
Registered at
2010-12-03 17:49:57
2012-01-29 23:20:56 - Re: My SOL race history site
This is AWESOME!!

Well Done!

SP
Posted by
hmm


Users avatar

Posts
118
Registered at
2011-11-03 13:35:22
2012-02-09 21:47:51 - Re: My SOL race history site
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.
Posted by
AGage


Users avatar

Posts
411
Registered at
2008-12-27 10:31:57
2012-02-10 02:57:28 - Re: My SOL race history site
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... __/)/)_/)__
Posted by
zero


Users avatar

Posts
120
Registered at
2010-02-07 16:56:30
2012-02-10 18:45:36 - Re: My SOL race history site
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:

Marstrand to Cowes 2025


We invite you to another race, which will kick off the third quarter of our ARCH series. We'll set off from Marstrand, Sweden, which, along with Skagen, Denmark, marks the line commonly recognised as the border separating the Baltic Sea from the North Sea. The 650nm route will take our Ripitide 50 across the North Sea and the English Channel to Cowes, England. Watch out for the fast ferries crossing the Channel from Calais to Dover 😊.
Race #1935
INFO from brainaid.de
Riptide 50 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking:
ARQ3 - ARCH - SUPSOL – SYC
Race starts: Jul 28th 17:00 Registration Open!
▶ Flash
GO TO RACE

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


How ever shall I return to report with clear report to the Sultan – asked Sinbad. It must be told this island and all its fables shall be expunged from the annals of every thousand and one night. The wind howls here, and sun be none (it’s Winter, Sin, ed.) and all days from the west, but let’s launch anyway and see if we can work our SOL Balloon north as the days pass aiming for Asthralaya, where The Mahabharata tells the ancients once tested mighty weapons, about a quarter and a million qasbah away (2500nm, ed.), perhaps one month.
Race #1885
INFOby brainaid.de
SOL Balloon PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: SYC - SBB
Race starts: Jul 23rd 11:00 Registration Open!
▶ Flash
GO TO RACE

Tall Ships Races 2025 - Aberdeen to Kristiansand


Welcome to the third of four virtual Tall Ships Races in European waters which are concurrently being organized in-real-life by Sail Training International . This third race is from Aberdeen in Scotland east across the North Sea to Norway’s Kristiansand; circa 330nm in Sailonline’s magnificent 90m Barque.
NOTE: Starts and Finishes in tall ships racing are always offshore to avoid conflict with shipping and shipping lanes; online and real-life may not match exactly.
Race #1925
INFO by brainaid.de
Barque 90m PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: TS - SYC
Race starts: Jul 22nd 16:00 Registration Open!
▶ Flash
GO TO RACE

Nantucket Sprint 2025


Welcome to Nantucket, from whence Herman Melville’s Cap’n Ahab sailed round The Horn into the northern Pacific Ocean to hunt the gray whale - whose migrations are celebrated elsewhere in SOL’s Q4 schedule - he never to return. And whaling too, as the 19th C progressed, like Ahab disappeared from Nantucket as the harbour silted up and mainland Massachusetts whaling stations benefited from rail connections. But beach life, yachting and nostalgia has rescued the island from oblivion, so to celebrate leisure, SOL gives you the Nantucket Sprint - 25nm in 29er_XX’s from Great Point to Muskeget & Tuckernuck Islands across the sound to a finish just inside the mouth of the harbour. Enjoy!
Race 1936
INFO by brainaid.de
29er_XX PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking:
SPRQ3 - SPRCH - SUPSOL – SYC
RACE CLOSE: Friday,
July 25 at 2300 UTC.
Race starts: Jul 19th 15:00 Registration Closed
▶ Flash
GO TO RACE

Suursaari TIMED Race 2025

The first TIMED race of the northern hemisphere Summer takes us to the Gulf of Finland on a 165nm zig-zagging course beginning and ending in the seacoast village of Haukilahti and circling the island of Suursaari. It’s only appropriate that the boat for this race is Finland’s own Club Swan 50. This is a TIMEDrace so you may RE-REGISTER HEREto 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 #1928
INFOby brainaid.de
PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking:
TRQ3 - TRCH - SUPSOL - SYC
RACE CLOSE: Saturday,
26 July at 23:00 UTC
Race starts: Jul 13th 12:00 Registration Open!
▶ Flash
GO TO RACE

Young Island to Great Nicobar 2025

The adventure continues as we launch this fifth leg of the RWW series, racing from Young Island to Great Nicobar on the edge of the Bay of Bengal. Get ready for a chilling start as we set sail on the seventh leg of the 2025 Ocean Championship Series! A 5200nm journey of endurance, strategy, and pure sailing excitement. This leg will be pursued aboard the Super Maxi 100v2, pushing sailors to their limits. Do you have what it takes to conquer the Indian Ocean? Join us and put your skills to the ultimate test!
PRIZE: SMPF
Race #1929
INFO by brainaid.de
Super Maxi 100 v2 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: OCQ3 - RWW - OCCH - SUPSOL - SYC
Race starts: Jul 07th 11:00 Registration Closed
▶ Flash
GO TO RACE

Go to race archive

SYC Ranking

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

View full list

Series

Mobile Client

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

The mobile client