tint::tfloat
: Cast a temporal integer to a temporal float
tfloat::tint
: Cast a temporal float to a temporal integer
tgeompoint::tgeogpoint
: Cast a temporal geometry point to a temporal geography point
tgeogpoint::tgeompoint
: Cast a temporal geography point to a temporal geometry point
tgeompoint::geometry, tgeogpoint::geography
: Cast a temporal point to a PostGIS trajectory
geometry::tgeompoint, geography::tgeogpoint
: Cast a PostGIS trajectory to a temporal point
ttypeinst, ttypei, ttypeseq, ttypes
: Transform a temporal value to another subtype
toLinear
: Transform a temporal value with continuous base type from stepwise to linear interpolation
appendInstant
: Append a temporal instant to a temporal value
merge
: Merge temporal values
memSize
: Get the memory size in bytes
tempSubtype
: Get the temporal subtype
interpolation
: Get the interpolation
getValue
: Get the value
getValues
: Get the values
startValue
: Get the start value
endValue
: Get the end value
minValue
: Get the minimum value
maxValue
: Get the maximum value
valueRange
: Get the value range
valueAtTimestamp
: Get the value at a timestamp
getTimestamp
: Get the timestamp
getTime
: Get the time
duration
: Get the duration
timespan
: Get the timespan ignoring the potential time gaps
period
: Get the period on which the temporal value is defined ignoring the potential time gaps
numInstants
: Get the number of different instants
startInstant
: Get the start instant
endInstant
: Get the end instant
instantN
: Get the n-th different instant
instants
: Get the different instants
numTimestamps
: Get the number of different timestamps
startTimestamp
: Get the start timestamp
endTimestamp
: Get the end timestamp
timestampN
: Get the n-th different timestamp
timestamps
: Get the different timestamps
numSequences
: Get the number of sequences
startSequence
: Get the start sequence
endSequence
: Get the end sequence
sequenceN
: Get the n-th sequence
sequences
: Get the sequences
shift
: Shift the time span of the temporal value by an interval
tscale
: Scale the time span of the temporal value to an interval
shiftTscale
: Shift and scale the time span the temporal value with the intervals
intersectsTimestamp
: Does the temporal value intersect the timestamp?
intersectsTimestampSet
: Does the temporal value intersect the timestamp set?
intersectsPeriod
: Does the temporal value intersect the period?
intersectsPeriodSet
: Does the temporal value intersect the period set?
twAvg
: Get the time-weighted average
asText
: Get the Well-Known Text (WKT) representation
asEWKT
: Get the Extended Well-Known Text (EWKT) representation
asMFJSON
: Get the Moving Features JSON representation
asBinary
: Get the Well-Known Binary (WKB) representation
asEWKB
: Get the Extended Well-Known Binary (EWKB) representation
asHexEWKB
: Get the Hexadecimal Extended Well-Known Binary (EWKB) representation as text
fromMFJSON
: Input a temporal point from a Moving Features JSON representation
fromEWKB
: Input a temporal point from an Extended Well-Known Binary (EWKB) representation
SRID
: Get the spatial reference identifier
setSRID
: Set the spatial reference identifier
transform
: Transform to a different spatial reference
setPrecision
: Round the coordinate values to a number of decimal places
getX
: Get the X coordinate values as a temporal float
getY
: Get the Y coordinate values as a temporal float
getZ
: Get the Z coordinate values as a temporal float
length
: Get the length traversed by the temporal point
cumulativeLength
: Get the cumulative length traversed by the temporal point
speed
: Get the speed of the temporal point in units per second
twCentroid
: Get the time-weighted centroid
azimuth
: Get the temporal azimuth
nearestApproachInstant
: Get the instant of the first temporal point at which the two arguments are at the nearest distance
nearestApproachDistance
: Get the smallest distance ever
shortestLine
: Get the line connecting the nearest approach point
simplify
: Simplify a temporal point using a generalization of the Douglas-Peucker algorithm
geoMeasure
: Construct a geometry/geography with M measure from a temporal point and a temporal float
atValue
: Restrict to a value
atValues
: Restrict to an array of values
atRange
: Restrict to a range
atRanges
: Restrict to an array of ranges
atMin
: Restrict to the minimum value
atMax
: Restrict to the maximum value
atGeometry
: Restrict to a geometry
atTimestamp
: Restrict to a timestamp
atTimestampSet
: Restrict to a timestamp set
atPeriod
: Restrict to a period
atPeriodSet
: Restrict to a period set
atTbox
: Restrict to a tbox
atStbox
: Restrict to an stbox
minusValue
: Difference with a value
minusValues
: Difference with an array of values
minusRange
: Difference with a range
minusRanges
: Difference with an array of ranges
minusMin
: Difference with the minimum value
minusMax
: Difference with the maximum value
minusGeometry
: Difference with a geometry
minusTimestamp
: Difference with a timestamp
minusTimestampSet
: Difference with a timestamp set
minusPeriod
: Difference with period
minusPeriodSet
: Difference with a period set
minusTbox
: Difference with a tbox
minusStbox
: Difference with an stbox
=
: Are the temporal values equal?
<>
: Are the temporal values different?
<
: Is the first temporal value less than the second one?
>
: Is the first temporal value greater than the second one?
<=
: Is the first temporal value less than or equal to the second one?
>=
: Is the first temporal value greater than or equal to the second one?
?=
: Is the temporal value ever equal to the value?
?<>
: Is the temporal value ever different from the value?
?<
: Is the temporal value ever less than the value?
?>
: Is the temporal value ever greater than the value?
?<=
: Is the temporal value ever less than or equal to the value?
?>=
: Is the temporal value ever greater than or equal to the value?
%=
: Is the temporal value always equal to the value?
%<>
: Is the temporal value always different to the value?
%<
: Is the temporal value always less than the value?
%>
: Is the temporal value always greater than the value?
%<=
: Is the temporal value always less than or equal to the value?
%>=
: Is the temporal value always greater than or equal to the value?
contains
: May contain
containsproperly
: May contain properly
covers
: May cover
coveredby
: May be covered by
crosses
: May cross
disjoint
: May be disjoint
equals
: May be equal
intersects
: May intersect
overlaps
: May overlap
touches
: May touch
within
: May be within
dwithin
: May be at distance within
relate
: May relate
tcontains
: Temporal contains
tcovers
: Temporal covers
tcoveredby
: Temporal covered by
tdisjoint
: Temporal disjoint
tequals
: Temporal equals
tintersects
: Temporal intersects
ttouches
: Temporal touches
twithin
: Temporal within
tdwithin
: Temporal distance within
trelate
: Temporal relate
tcount
: Temporal count
extent
: Bounding box extent
tand
: Temporal and
tor
: Temporal or
tmin
: Temporal minimum
tmax
: Temporal maximum
tsum
: Temporal sum
tavg
: Temporal average
wmin
: Window minimum
wmax
: Window maximum
wcount
: Window count
wsum
: Window sum
wavg
: Window average
tcentroid
: Temporal centroid
mobilitydb_version
: Get the version of the MobilityDB extension
mobilitydb_full_version
: Get the versions of the MobilityDB extension and its dependencies