On 10/05/2023 10:00, Tarquin Wilton-Jones via Therion wrote: >> 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. > > Very nice! > Thanks for sharing.
One thing I do notice, is that like Therion's own PDF surveying length stats, the script does not give any length for surface legs, so surface surveyors are not given any credit. https://github.com/therion/therion/issues/132 I think this is a bug in Therion's SQL output: create table CENTRELINE (ID integer, SURVEY_ID integer, TITLE varchar(60), TOPO_DATE date, EXPLO_DATE date, LENGTH real, SURFACE_LENGTH real, DUPLICATE_LENGTH real); ... insert into CENTRELINE values (4147, 4146, NULL, NULL, NULL, 0.00, 0.00, 0.00); All of my surface surveys have 0 length. The python script has the same issue though, in that it only shows "length", and ignores surface surveys. _______________________________________________ Therion mailing list Therion@speleo.sk https://mailman.speleo.sk/listinfo/therion