Return or set the spatial reference identifier, which for a temporal pose chain is the identifier of its outer frame
SRID({tpose,tposechain}) → integer
setSRID({tpose,tposechain},integer) → {tpose,tposechain}
SELECT SRID(tpose 'SRID=5676; [Pose(Point(0 0),1)@2001-01-01, Pose(Point(1 1),2)@2001-01-02)')); -- 5676 SELECT asEWKT(setSRID(tpose '[Pose(Point(0 0),1)@2001-01-01, Pose(Point(1 1),2)@2001-01-02)', 5676)); -- SRID=5676;[Pose(POINT(0 0),1)@2001-01-01, Pose(POINT(1 1),2)@2001-01-02)
Transform to a spatial reference identifier
transform({tpose,tposechain},integer) → {tpose,tposechain}
transformPipeline({tpose,tposechain},pipeline text,srid integer,
is_forward boolean=true) → {tpose,tposechain}
The chain of every instant is transformed as the corresponding static chain is, which is to say that only the outer link is transformed, as described for transform.
Each instant's pose is transformed as the corresponding static pose is, orientation correction included, as described for transform. The same holds for a poseset. A trgeometry pairs its poses with a reference geometry that shares their frame, and transformation to another SRID is not supported for it.
SELECT asEWKT(transform(tpose 'SRID=4326;Pose(Point(4.35 50.85),1)@2001-01-01', 3812)); -- SRID=3812;Pose(POINT(648679.0180353033 671067.0556381135),1)@2001-01-01
WITH test(tpose, pipeline) AS (
SELECT tpose 'SRID=4326;{Pose(Point(4.3525 50.846667),1)@2001-01-01,
Pose(Point(-0.1275 51.507222),2)@2001-01-02}',
text 'urn:ogc:def:coordinateOperation:EPSG::16031' )
SELECT asEWKT(transformPipeline(transformPipeline(tpose, pipeline, 4326), pipeline, 4326,
false), 6) FROM test;
/* SRID=4326;{Pose(POINT(4.3525 50.846667),1)@2001-01-01,
Pose(POINT(-0.1275 51.507222),2)@2001-01-02} */