[Therion] Generating list of drawers

[Tarquin Wilton-Jones]

> But I need "drawed length", to see who contributet how much to the maps 
> drawings.


Is that how Therion works it out on the PDFs? I would have assumed it 
uses "how many scraps" with that person as -author, since it cannot 
really work out the "length". I could have a scrap containing only one 
station, which would mean 0 length. I could have a scrap containing only 
stations 1 and 100 (if the passage forms a loop). I could also have 5 
scraps overlaying each other, all covering the same 2 stations. I don't 
think Therion uses any logic to count stations-per-scrap in order to 
boost the relative numbers. This is why there is no option for
"statistics carto-length on"
Instead, it just ranks people by number of scraps. I think.

Assuming you mean length of cave covered by:
scrap somethingSP -projection plan -author 2025.01.01 "Foo bar"
(which it sounds like you do) rather than:
team "Baz Qux" notes pictures
Since both of those are someone doing drawings.

I think you need to do a query for scraps, and
count(*) AS scrapcount GROUP BY author
(Sorry, I don't play with the SQL so I don't know the column titles, 
hoping this is enough to make sense for you.)

This does mean that if you have one scrap covering 500 metres of cave, 
it means the same as one scrap covering 1 metre of cave. But I think 
that is what Therion does.