ttype_inst
: Constructor for temporal types of instant subtype
ttype_instset
: Constructor for temporal types of instant set subtype
ttype_seq
: Constructor for temporal types of sequence subtype
ttype_seqset
: Constructor for temporal types of sequence set subtype
ttype::period
: Cast a temporal value to a period
tnumber::range
: Cast a temporal number to a range
tnumber::tbox
: Cast a temporal number to a tbox
ttype::period
: Cast a temporal point to an stbox
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
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
segments
: Get the segments
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
ttype_inst, ttype_instset, ttype_seq, ttype_seqset
: 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
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?
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
tgeompointFromText
: Input a temporal geometry point from a Well-Known Text (WKT) representation
tgeogpointFromText
: Input a temporal geography point from a Well-Known Text (WKT) representation
tgeompointFromEWKT
: Input a temporal geometry point from an Extended Well-Known Text (EWKT) representation
tgeogpointFromEWKT
: Input a temporal geography point from an Extended Well-Known Text (EWKT) representation
tgeompointFromMFJSON
: Input a temporal geometry point from a Moving Features JSON representation
tgeogpointFromMFJSON
: Input a temporal geography geometry point from a Moving Features JSON representation
tgeompointFromBinary
: Input a temporal geometry point from a Well-Known Binary (WKB) representation
tgeogpointFromBinary
: Input a temporal geography point from a Well-Known Binary (WKB) representation
tgeompointFromEWKB
: Input a temporal geometry point from an Extended Well-Known Binary (EWKB) representation
tgeogpointFromEWKB
: Input a temporal geography point from an Extended Well-Known Binary (EWKB) representation
tgeompointFromHexEWKB
: Input a temporal geometry point from an Hexadecimal Extended Well-Known Binary (EWKB) representation as text
tgeogpointFromHexEWKB
: Input a temporal geography point from an Hexadecimal Extended Well-Known Binary (EWKB) representation as text
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
isSimple
: Returns true if the temporal point does not spatially self-intersect
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
bearing
: Get the temporal bearing
setPrecision
: Round the coordinate values to a number of decimal places
makeSimple
: Returns an array of fragments of the temporal point which are simple
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
asMVTGeom
: Transform a temporal geometric point into the coordinate space of a Mapbox Vector Tile
|=|
: Get the smallest distance ever
nearestApproachInstant
: Get the instant of the first temporal point at which the two arguments are at the nearest distance
shortestLine
: Get the line connecting the nearest approach point
<->
: Get the temporal distance
contains
: May contain
disjoint
: May be disjoint
dwithin
: May be at distance within
intersects
: May intersect
touches
: May touch
tcontains
: Temporal contains
tdisjoint
: Temporal disjoint
tdwithin
: Temporal distance within
tintersects
: Temporal intersects
ttouches
: Temporal touches
frechetDistance
: Get the discrete Fréchet distance between two temporal values
frechetDistancePath
: Get the correspondence pairs between two temporal values with respect to the discrete Fréchet distance
dynamicTimeWarp
: Get the Dynamic Time Warp distance between two temporal values
dynamicTimeWarpPath
: Get the correspondence pairs between two temporal values with respect to the Dynamic Time Warp distance
bucketList
: Returns a set of couples (index, bucket) that cover the range or period with buckets of the same width or duration aligned with the origin
valueBucket
: Returns the start value of the bucket that contains the input number.
rangeBucket
: Returns the range in the bucket space that contains the input number
timeBucket
: Returns the start timestamp of the bucket that contains the input timestamp.
periodBucket
: Returns a period in the bucket space that contains the input timestamp
multidimGrid
: Returns a set of couples (index, tile) that covers the box with multidimensional tiles of the same size and duration.
multidimTile
: Returns the tile of the multidimensional grid that contains the value and the timestamp
valueSplit
: Fragment the temporal number with respect to value buckets
timeSplit
: Fragment the temporal value with respect to time buckets
valueTimeSplit
: Fragment the temporal number with respect to the tiles in a value-time grid
spaceSplit
: Fragment the temporal point with respect to tiles in a spatial grid
spaceTimeSplit
: Fragment the temporal point with respect to tiles in a spatiotemporal grid
mobilitydb_version
: Get the version of the MobilityDB extension
mobilitydb_full_version
: Get the versions of the MobilityDB extension and its dependencies