更改某条轨迹的空间参考标识符(SRID)。
语法
trajectory ST_SetSRID(trajectory traj, int srid);
参数
参数名称 | 描述 |
---|---|
traj | 轨迹对象。 |
srid | 目标SRID。 |
描述
将轨迹的SRID设置为给定的值,但不更改其它内容。
示例
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);
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)