pcpoint: Build a 2D or 3D pcpoint directly from x/y(/z) coordinates

pcpoint: Build a pcpoint from the coordinates of every dimension of the schema

pcpatch: Build a pcpatch from the coordinates of its points, one point after another

pcpatch: Build a pcpatch from a variadic list of pcpoints sharing the same pcid

pcid: Return the schema id of a pcpoint or pcpatch

getX, getY, getZ: Return a coordinate of a pcpoint, NULL if the dimension is absent from the schema

getDim: Return any named dimension of a pcpoint, NULL if the name is unknown for the schema

SRID: Return the spatial reference identifier (inherited from the schema)

geometry: Return the multipoint of the positions the points of a patch occupy

set: Construct a set from an array of values, all of which must share the same pcid

tpcbox, tpcbox_z, tpcbox_t, tpcbox_xt, tpcbox_zt: Construct a tpcbox from explicit X/Y/Z/T bounds and a pcid, whose schema states the SRID

tpcbox: Convert a pcpoint to a degenerate (zero-extent) tpcbox; SRID and pcid come from the schema

tpcbox: Convert a pcpatch to a tpcbox

hasX, hasZ, hasT: Return whether a tpcbox has the X/Y, Z, or T dimensions set

xmin, xmax, ymin, ymax, zmin, zmax: Return a coordinate bound, NULL if the corresponding dimension is absent

tmin, tmax: Return a temporal bound, NULL if the box has no T dimension

pcid, SRID: Return the schema id and the SRID its schema states

round: Return a tpcbox with coordinates rounded to a given number of decimal digits

setSRID: Return a tpcbox stating a reference system its schema does not state

+, *: Union and intersection of two tpcboxes

&&, @>, <@, ~=, -|-: Topological operators

<<, &<, >>, &>, <<|, &<|, |>>, |&>, <</, &</, />>, /&>, <<#, &<#, #>>, #&>: Position operators

=, <>, <, <=, >=, >: Compare two tpcboxes; total order over the canonical encoding (pcid, srid, flags, period, then spatial bounds in XYZ-min/max order)

asText: Return the text representation of a tpcpoint, or of an array of them, and cast a tpcpoint to text

asMFJSON: Return the Moving Features JSON (MF-JSON) representation

tpcpoint: Constructor for temporal point cloud points having a constant value

tpcpointSeq: Constructor for temporal point cloud points of sequence subtype

tpcpointSeqSet: Construct a temporal pcpoint of sequence-set subtype from an array of sequences

::: Convert a temporal point cloud point to a temporal geometry point

pcid: Return the pgPointCloud schema id shared by all instants

SRID: Return the SRID inherited from the schema

getX, getY, getZ: Project a tpcpoint onto a spatial dimension, yielding a tfloat

getDim: Project a tpcpoint onto any named schema dimension, yielding a tfloat

tpcpointInst, tpcpointSeq, tpcpointSeqSet: Transform a tpcpoint to another subtype

setInterp: Transform a tpcpoint to another interpolation

insert, update: Insert a tpcpoint into another one, or update another one with it

deleteTime: Delete a time selector (timestamp, set, period, or spanset) from a tpcpoint

appendInstant, appendSequence: Append an instant or a sequence to a tpcpoint

atValue, minusValue, atValues, minusValues: Restrict a tpcpoint to (the complement of) a pcpoint value or a set of pcpoint values

atTime, minusTime: Restrict a tpcpoint to a time selector (timestamp, period, set, or spanset), or remove it

atTpcbox, minusTpcbox: Restrict a tpcpoint to the spatial / temporal extent of a tpcbox, or remove it

beforeTimestamp, afterTimestamp: Restrict a tpcpoint to the instants before or after a timestamp

unnest: Return the distinct values of a tpcpoint with the span set on which each of them is taken

timeSplit: Split a tpcpoint into fragments, one per time bin

spans: Return the array of time spans of a tpcpoint's segments

splitNSpans, splitEachNSpans: Return the time spans of a tpcpoint split into a given number of bins, or with a given number of segments per bin

&&, @>, <@, ~=, -|-: Topological operators

<<, >>, <<|, |>>, <</, />>, <<#, #>>: Position operators

|=|: Return the smallest distance ever

nearestApproachInstant: Return the instant of the tpcpoint at which the two arguments are at the nearest distance

shortestLine: Return the line connecting the nearest approach point between the two arguments

<->: Return the temporal distance

eContains, aContains, eCovers, aCovers, eDisjoint, aDisjoint, eDwithin, aDwithin, eIntersects, aIntersects, eTouches, aTouches: Ever and always relationships

tContains, tCovers, tDisjoint, tDwithin, tIntersects, tTouches: Temporal spatial relationships

=, <>, <, <=, >=, >: Traditional comparisons

?=, %=: Ever and always comparisons

#=: Temporal comparisons

asText: Return the text representation of a tpcpatch, or of an array of them, and cast a tpcpatch to text

asMFJSON: Return the Moving Features JSON (MF-JSON) representation

tpcpatch: Construct a temporal pcpatch of instant subtype

tpcpatchSeq: Construct a temporal pcpatch of sequence subtype

tpcpatchSeqSet: Construct a temporal pcpatch of sequence-set subtype

tgeometry: Convert a temporal patch into the temporal geometry of the multipoints its patches occupy

startNumPoints, endNumPoints: Return the number of points in the patch carried by the first or last instant

numPoints: Return the total number of points across every instant's patch

points: Set-returning function: emits one row per (instant timestamp, point) by walking each instant's patch and decomposing it through pgPointCloud's in-memory C API

tpcpatchInst, tpcpatchSeq, tpcpatchSeqSet: Transform a tpcpatch to another subtype

setInterp: Transform a tpcpatch to another interpolation

insert, update: Insert a tpcpatch into another one, or update another one with it

deleteTime: Delete a time selector (timestamp, set, period, or spanset) from a tpcpatch

appendInstant, appendSequence: Append an instant or a sequence to a tpcpatch

atValue, minusValue, atValues, minusValues: Restrict a tpcpatch to (the complement of) a pcpatch value or a set of pcpatch values

atTpcbox, minusTpcbox: Restrict a tpcpatch to the instants whose patch passes a coarse PCBOUNDS overlap test against the tpcbox, or remove them

atTpcboxFine, minusTpcboxFine: Restrict a tpcpatch to the points of each instant that the tpcbox holds, or remove them

atGeometry, minusGeometry: Restrict a tpcpatch to the points whose XY projection intersects (or does not intersect, for minus) a 2D geometry

beforeTimestamp, afterTimestamp: Restrict a tpcpatch to the instants before or after a timestamp

unnest: Return the distinct values of a tpcpatch with the span set on which each of them is taken

timeSplit: Split a tpcpatch into fragments, one per time bin

spans: Return the array of time spans of a tpcpatch's segments

splitNSpans, splitEachNSpans: Return the time spans of a tpcpatch split into a given number of bins, or with a given number of segments per bin

&&, @>, <@, ~=, -|-: Topological operators

<<, >>, <<|, |>>, <</, />>, <<#, #>>: Position operators

|=|: Return the smallest distance ever

eIntersects, aIntersects, eContains, aContains, eCovers, aCovers, eDisjoint, aDisjoint, eTouches, aTouches, eDwithin, aDwithin: Return true iff at least one point in any of the tpcpatch's instants intersects the geometry (XY only)

tContains, tCovers, tDisjoint, tDwithin, tIntersects, tTouches: Temporal spatial relationships

?=, %=: Ever and always comparisons

#=: Temporal comparisons