Functions and Operators for Temporal Types

Constructor Functions

  • ttypeinst: Constructor for temporal types of instant subtype

  • ttypei: Constructor for temporal types of instant set subtype

  • ttypeseq: Constructor for temporal types of sequence subtype

  • ttypes: Constructor for temporal types of sequence set subtype

Casting

Transformation Functions

Accessor Functions

Spatial Functions

  • 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

Restriction Functions

Difference Functions

Comparison Operators

  • =: 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?

Ever and Always Comparison Operators

  • ?=: 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?

Temporal Comparison Operators

  • #=: Temporal equal

  • #<>: Temporal different

  • #<: Temporal less than

  • #>: Temporal greater than

  • #<=: Temporal less than or equal to

  • #>=: Temporal greater than or equal to

Mathematical Functions and Operators

  • +: Temporal addition

  • -: Temporal subtraction

  • *: Temporal multiplication

  • /: Temporal division

  • round: Round the values to a number of decimal places

  • degrees: Convert from radians to degrees

  • derivative: Get the derivative over time of the temporal float in units per second

Boolean Operators

  • &: Temporal and

  • |: Temporal or

  • ~: Temporal not

Text Functions and Operators

  • ||: Temporal text concatenation

  • upper: Transform to uppercase

  • lower: Transform to lowercase

Distance Operators

  • |=|: Get the smallest distance ever

  • <->: Get the temporal distance

Spatial Relationships for Temporal Points

Possible Spatial Relationships

Temporal Spatial Relationships

Aggregate Functions for Temporal Types

Utility Functions