Well, that gives me "survey length per person" (isn't it?)
But I need "drawed length", to see who contributet how much to the maps
drawings.
Am 2025-03-06 17:49, schrieb Eoghan:
Hi Benedikt,
I wrote up this for you as an example.
SELECT DISTINCT p.NAME, p.SURNAME, SUM(c.LENGTH) OVER(PARTITION BY
p.NAME) as sum_len FROM PERSON p JOIN TOPO t ON p.ID = t.PERSON_ID JOIN
CENTRELINE c ON c.ID = t.CENTRELINE_ID;
I hope this get’s you started.
Eoghan
On 20 Feb 2025, at 13:54, Benedikt Hallinger via Therion
<[email protected]> wrote:
Hi,
before I dig into SQL myself, does by chance somebody already made a
script or SQL to generate a list showing: "who has drawn how much
length
of the surveys".
Something along:
Person A: 250m
Person B: 199m
Person C: 80m
...
Thank you :)
_______________________________________________
Therion mailing list
[email protected]
https://mailman.speleo.sk/listinfo/therion
_______________________________________________
Therion mailing list
[email protected]
https://mailman.speleo.sk/listinfo/therion
