ST_Transform(INT) method

Syntax

geometry-expression.ST_Transform(INT srid)

Parameters

• srid – The SRID of the result.

Returns

ST_Geometry Returns a copy of the geometry value transformed into the specified spatial reference system.

Examples

• Example 1 – The following example returns the result Point (184755.86861 -444218.175691). It transforms a point in Los Angeles which is specified in longitude and latitude to the projected planar SRID 3310 ("NAD83 / California Albers"). This example assumes that the 'st_geometry_predefined_srs' feature has been installed by the sa_install_feature system procedure. See sa_install_feature system procedure.

  SELECT NEW ST_Point( -118, 34, 4326 ).ST_Transform( 3310 )

Standards

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