The three aggregate functions for temporal poses are illustrated next.
Temporal count
tCount(tpose) → {tintSeq,tintSeqSet}
WITH Temp(temp) AS ( SELECT tpose '[Pose(Point(1 1), 0.1)@2001-01-01, Pose(Point(1 1), 0.3)@2001-01-03)' UNION SELECT tpose '[Pose(Point(1 1), 0.2)@2001-01-02, Pose(Point(1 1), 0.4)@2001-01-04)' UNION SELECT tpose '[Pose(Point(1 1), 0.3)@2001-01-03, Pose(Point(1 1), 0.5)@2001-01-05)' ) SELECT tCount(Temp) FROM Temp; -- {[1@2001-01-01, 2@2001-01-02, 1@2001-01-04, 1@2001-01-05)}
Window count
wCount(tpose) → {tintSeq,tintSeqSet}
WITH Temp(temp) AS ( SELECT tpose '[Pose(Point(1 1), 0.1)@2001-01-01, Pose(Point(1 1), 0.3)@2001-01-03)' UNION SELECT tpose '[Pose(Point(1 1), 0.2)@2001-01-02, Pose(Point(1 1), 0.4)@2001-01-04)' UNION SELECT tpose '[Pose(Point(1 1), 0.3)@2001-01-03, Pose(Point(1 1), 0.5)@2001-01-05)' ) SELECT wCount(Temp, '1 day') FROM Temp; /* {[1@2001-01-01, 2@2001-01-02, 3@2001-01-03, 2@2001-01-04, 1@2001-01-05, 1@2001-01-06)} */