Transforms the coordinates of a spatial object from one spatial reference system (SRS) to another.
Syntax
meshgeom ST_Transform(meshgeom geom, integer srid);
sfmesh ST_Transform(sfmesh sfmeshObject, integer srid);Parameters
| Parameter | Type | Description |
|---|---|---|
geom | meshgeom | The meshgeom object to transform. |
sfmeshObject | sfmesh | The sfmesh object to transform. |
srid | integer | The spatial reference identifier (SRID) of the target SRS. |
Examples
The following example transforms a meshgeom object from CGCS2000 (SRID 4490) to Web Mercator (SRID 3857).
SELECT ST_AsEWKT(
ST_Transform(
ST_MeshGeomFromText('Srid=4490;MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))'),
3857
)
);Output:
SRID=3857;MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 1118889.97485796 3,1113194.90793274 1118889.97485796 1,1113194.90793274 0 1),INDEX((0,1,2),(1,2,3)))))