All Products
Search
Document Center

PolarDB:ST_trajectorySpatial

Last Updated:Aug 21, 2026

Returns the spatial geometry object of a trajectory object.

Syntax

geometry ST_trajectorySpatial(trajectory traj);
geometry ST_trajSpatial(trajectory traj);

ST_trajSpatial is an alias for ST_trajectorySpatial.

Parameters

ParameterDescription
trajThe trajectory object.

Example

Retrieve the spatial path of each trajectory in traj_table as well-known text (WKT):

Select ST_AsText(ST_trajectorySpatial(traj)) FROM traj_table;
            st_astext
----------------------------------
 LINESTRING(114 35,115 36,116 37)