ST_GeomFromText method

ST_Geometry::ST_GeomFromText(character-string[, srid])

Name	Type	Description
character-string	LONG VARCHAR	A string containing the text representation of a geometry. The input can be in any supported text input format, including Well Known Text (WKT) or Extended Well Known Text (EWKT).
srid	INT	The SRID of the result. If not specified and the input string does not contain a SRID, the default is 0.

ST_Geometry Returns a geometry value of the appropriate type based on the source string.
The spatial reference system identifier of the result is the given by parameter srid.

Parses a text string representing a geometry and creates a geometry value of the appropriate type. This method is used by the server when evaluating a cast from a character string to a geometry type.

The server detects the format of the input string. Some input formats contain a SRID definition. If provided, the srid parameter must match any value taken from the input string.

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

The following example returns the result LineString (1 2, 5 7).

SELECT ST_Geometry::ST_GeomFromText( 'LineString( 1 2, 5 7 )', 4326 )

ST_GeomFromText method

Syntax

Parameters

Returns

Remarks

See also

Standards and compatibility

Example