[Therion] Statistics on surveys of a network

[Philippe Vernant]

Hi guys,

Thanks for the answers. I wrote a python script. It is far from being elegant but it does the job. I attach it to this message in case it can be helpful to some of you.

Cheers,
Phil

 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: sql2sur.py
Type: text/x-python-script
Size: 1412 bytes
Desc: not available
URL: <http://mailman.speleo.sk/pipermail/therion/attachments/20230510/2c57a842/attachment.bin>
-------------- next part --------------


> On 3 May 2023, at 23:44, Andrew Atkinson <andrew at wotcc.org.uk> wrote:
> 
> 
> 
> On 03/05/2023 21:40, Tarquin Wilton-Jones via Therion wrote:
>> However, I don't know what it will output if you ask it to export a
>> database. Probably nothing useful.
> 
> As fr as I remember it was very useful, I wrote a web page that queried it, this was over 10 years ago, the page is still there but it appears that I have removed the database at some point
> 
> https://wotcc.org.uk/Cheddar/
> 
> 
> 
> The therion book p66 gives the structure. For things like who did what, I think each leg has the data of who was on the team doing what. With the right sql query you should be able to find out most things recorded.
> 
> Andrew
> _______________________________________________
> Therion mailing list
> Therion at speleo.sk
> https://mailman.speleo.sk/listinfo/therion