Sets the spatial reference identifier (SRID) of a trajectory.
Syntax
trajectory ST_SetSRID(trajectory traj, int srid);Parameters
| Parameter | Type | Description |
|---|---|---|
traj | trajectory | The trajectory whose SRID to set. |
srid | int | The SRID to assign to the trajectory. |
Description
ST_SetSRID assigns a new SRID to a trajectory without modifying its coordinates or any other trajectory data. It only updates the SRID metadata.
Example
SELECT ST_setSRID('{"trajectory":{"version":1,"type":"STPOINT","leafcount":2,"start_time":"2007-05-27 00:00:00","end_time":"2007-05-28 08:36:47.846","spatial":"SRID=4326;LINESTRING(13.43593 52.41721,13.43593 52.41721)","timeline":["2007-05-27 00:00:00","2007-05-28 08:36:47.846"]}}'::trajectory
,4002);The output shows the same trajectory geometry with the SRID updated from 4326 to 4002:
st_setsrid
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
{"trajectory":{"version":1,"type":"STPOINT","leafcount":2,"start_time":"2007-05-27 00:00:00","end_time":"2007-05-28 08:36:48","spatial":"SRID=4002;LINESTRING(13.43593 52.41721,13.43593 52.41721)","timeline":["2007-05-27 00:00:00","2007-05-28 08:36:48"]}}
(1 row)