This topic describes the ST_Transform function, which transforms a trajectory between spatial references.

Syntax

trajectory ST_Transform(trajectory traj, int srid);

Parameters

Parameter Description
traj The trajectory that you want to transform.
srid The spatial reference identifier (SRID) of the trajectory in the spatial reference to which you want to transform.
Note The trajectory can be transformed to the specified spatial reference only when the trajectory has an SRID.

Example

select ST_Transform('{"trajectory":{"version":1,"type":"STPOINT","leafcount":4,"start_time":"2020-11-03 08:00:00","end_time":"2020-11-03 18:03:20","spatial":"SRID=4326;LINESTRING(114.49211 37.97999,114.49211 37.97521,114.49191 37.98021,124 37)","timeline":["2020-11-03 08:00:00","2020-11-03 08:01:40","2020-11-03 08:03:20","2020-11-03 18:03:20"]}}'::trajectory, 2401);
                                                                                                                                                                                     st_transform                                                                                                                                                                                      
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 {"trajectory":{"version":1,"type":"STPOINT","leafcount":4,"start_time":"2020-11-03 08:00:00","end_time":"2020-11-03 18:03:20","spatial":"SRID=2401;LINESTRING(29019418.8397 5025539.47515,29019696.5878 5024992.53808,29019387.9428 5025555.44863,29954166.377 5430882.06455)","timeline":["2020-11-03 08:00:00","2020-11-03 08:01:40","2020-11-03 08:03:20","2020-11-03 18:03:20"]}}
(1 row)