ST_Transform |
|
Release 9.3 |
NOTE: The source and destination spatial references must have the same geographic datum.
sde.st_transform (g1 sde.st_geometry, srid integer)
st_transform (g1 st_geometry, srid integer)
CREATE TABLE transform_test (ln1 sde.st_linestring, ln2 sde.st_geometry);
INSERT INTO transform_test VALUES (
sde.st_linefromtext ('linestring (10.01 40.03, 92.32 29.39)', 102)
);
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.