ST_TransformGeom( ST_Geometry , LONG VARCHAR, LONG VARCHAR) method

Returns the geometry transformed using the given transform definition.

Syntax

ST_SpatialRefSys::ST_TransformGeom( ST_Geometry geom, LONG VARCHAR target_transform_definition, LONG VARCHAR source_transform_definition)

Parameters

geom – The geometry to be transformed
target_transform_definition – The target spatial reference system transform definition text
source_transform_definition – The source spatial reference system transform definition text. If not specified, the transform definition from the spatial reference system of the geom parameter is used.

Returns

ST_Geometry Returns the input geometry transformed using the given transform definition.

Examples

Example 1 – The following example returns the result Point (-5387692.968586 4763459.253243).

SELECT  ST_SpatialRefSys::ST_TransformGeom( NEW ST_Point(-63.57,44.65,4326), '+proj=robin +lon_0=0 +x_0=0 +y_0=0 +a=6371000 +b=6371000 +units=m  no_defs' ).ST_AsText('DecimalDigits=6')

Standards

SQL/MM (ISO/IEC 13249-3: 2006) Vendor extension