ST_Transform

Definition

ST_Transform converts the ST_Geometry into the spatial reference specified by the spatial reference ID (SRID).

Note:

The source and destination spatial references must have the same geographic datum.

Syntax

sde.st_transform (g1 sde.st_geometry, srid integer)

Return type

ST_Geometry

Example

The following CREATE TABLE statement creates the transform_test table, which has two ST_LineString columns, ln1 and ln2.

CREATE TABLE transform_test (ln1 sde.st_linestring, ln2 sde.st_geometry);

The following INSERT statement inserts an ST_LineString into ln1 with an SRID of 102.

INSERT INTO transform_test (ln1) VALUES (
sde.st_linefromtext ('linestring (10.01 40.03, 92.32 29.39)', 102)
);

The ST_Transform function converts the ST_LineString of ln1 from the coordinate reference that is assigned to SRID 102 to the coordinate reference assigned to SRID 105. The following UPDATE statement stores the transformed ST_LineString in column ln2.

UPDATE transform_test
SET ln2 = sde.st_transform (ln1, 105);

Note:

SRIDs 102 and 105 have to exist in the ST_SPATIAL_REFERENCES view, and both must have the same geographic datum.