Turnout and other Analytic Statistics

General
, ,
1

Hi Sailwave Users,

Has anyone used the data in Sailwave to produce turnout statistics or demographic analysis?
If so how have you done it, please?

I have started by importing the JSON file, created by Sailwave, into a database (PostgreSQL) column. I am now struggling to get the data out, which I think should be possible from what I have read. I have been able to get some data out but not the data I need for turnout / demographic analysis.

I want to use JSON because it will allow the import of data from Sailwave files that will have different set-ups but still allow extraction of information for aggregation analysis.

I am using PostgreSQL v17 because it seems to better support including JSON data in a column. I have not looked at Microsoft SQL because I am trying this on my Linux system.

I look forward to feedback.
Kind regards,
Huw

2

Think I could write a plugin which saved the data to a SQLite database fairly quickly. Certainly the competitor data would be easy. What other info do you need?

Jon

3

Hi Jon,
Thank you for the reply, much appreciated.

Ideally I would like but just competitor data would OK:

  • Event data including versions of Sailwave (unique key)Competitor data (competitor unique key, event foreign key)
  • Race data (race unique key, competitor foreign key)
  • Race results data (result unique key, race foreign key, ?competitor foreign key)

I would be interested in what other SUG members think.
Kind regards,
Huw

4

Hi Huw,

I too get asked at the end of each season to produce a list of the club’s most committed members (i.e. those who sailed the most days, not races). So I wondered if there had been any more development of this topic?

Many thanks, Jools.

5

Hi Jools,

I have given up on the route I was trying to follow using PostgreSQL and importing JSON.

However, I am following a different route to get some Sailwave data into a database. I have been provided two different ways of getting competitor data into a database and I am trying to extend to include race data and results information.

  • A proof on concept from Jon Eskdale in Visual Studio directly accessing a Sailwave file and creating an SQLlite database
  • A proof of concept by Andy Barrow using Python to import a JSON file created by Sailwave into a MySQL or MariaDB database

As I understand the Python solution better than the Visual Studio I am progressing with the Python route. I can see with this route a way to import into a database in addition to the competitor data, the race & results data that would be required to produce the information you are suggesting you want. It would require race dates to be entered in the race information.

What coding knowledge do you have?

Kind regards,
Huw

6

I do it by merging every race to create a huge series. For us thats about 96 races over the year. I then export it from Sailwave to mess about with it in excel. Its also how I calculate new personal handicaps for the following year by exporting all the BCR’s. Its very quick and easy to do.