ST_FormatWKT method

ST_SpatialRefSys::ST_FormatWKT(definition)

Name	Type	Description
definition	LONG VARCHAR	The spatial reference system definition text

LONG VARCHAR Returns a text string defining the spatial reference system in WKT.

Returns a formatted copy of the WKT spatial reference system definition.

The Well Known Text which describes spatial reference systems is a different format from the Well Known Text which describes geometries.

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

The following example returns the result GEOGCS["WGS 84", DATUM["WGS_1984", SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]], AUTHORITY["EPSG","6326"]], PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]], UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]], AUTHORITY["EPSG","4326"]].

SELECT  ST_SpatialRefSys::ST_FormatWKT('GEOGCS["WGS 84",DATUM["WGS_1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4326"]]')

ST_FormatWKT method

Syntax

Parameters

Returns

Remarks

Standards and compatibility

Example