Return the values
getValues(tnpoint) → npointset
SELECT getValues(tnpoint '{[NPoint(1, 0.3)@2001-01-01, NPoint(1, 0.5)@2001-01-02)}'); -- {"NPoint(1,0.3)","NPoint(1,0.5)"} SELECT getValues(tnpoint '{[NPoint(1, 0.3)@2001-01-01, NPoint(1, 0.3)@2001-01-02)}'); -- {"NPoint(1,0.3)"}
Return the road identifiers
routes(tnpoint) → bigintset
SELECT routes(tnpoint '{NPoint(3, 0.3)@2001-01-01, NPoint(1, 0.5)@2001-01-02}'); -- {1, 3}
Return the value at a timestamp
valueAtTimestamp(tnpoint,timestamptz) → npoint
SELECT valueAtTimestamp(tnpoint '[NPoint(1, 0.3)@2001-01-01, NPoint(1, 0.5)@2001-01-03)', '2001-01-02'); -- NPoint(1,0.4)
Return the length traversed by the temporal network point
length(tnpoint) → float
SELECT length(tnpoint '[NPoint(1, 0.3)@2001-01-01, NPoint(1, 0.5)@2001-01-02]'); -- 54.3757408468784
Return the cumulative length traversed by the temporal network point
cumulativeLength(tnpoint) → tfloat
SELECT cumulativeLength(tnpoint '{[NPoint(1, 0.3)@2001-01-01, NPoint(1, 0.5)@2001-01-02, NPoint(1, 0.5)@2001-01-03], [NPoint(1, 0.6)@2001-01-04, NPoint(1, 0.7)@2001-01-05]}'); /* {[0@2001-01-01, 54.3757408468784@2001-01-02, 54.3757408468784@2001-01-03], [54.3757408468784@2001-01-04, 81.5636112703177@2001-01-05]} */
Return the speed of the temporal network point in units per second
speed({tnpointSeq, tnpointSeqSet}) → tfloatSeqSet
SELECT speed(tnpoint '[NPoint(1, 0.1)@2001-01-01, NPoint(1, 0.4)@2001-01-02, NPoint(1, 0.6)@2001-01-03]') * 3600 * 24; /* Interp=Step;[21.4016800272077@2001-01-01, 14.2677866848051@2001-01-02, 14.2677866848051@2001-01-03] */