ST_PolyFromText function [Spatial]

Returns an ST_Polygon value, which is transformed from a LONG VARCHAR value containing the Well Known Text (WKT) representation of an ST_Polygon

Syntax

[DBO.]ST_PolyFromText(wkt[, srid])

Parameters

Name	Type	Description
wkt	LONG VARCHAR	The WKT representation.
srid	INT	The SRID of the result. If not specified, the default is 0.

Remarks

The ST_PolyFromText function is equivalent to the following:

CREATE FUNCTION DBO.ST_PolyFromText( wkt LONG VARCHAR, srid INT DEFAULT 0 )
RETURNS ST_Polygon
BEGIN
    DECLARE geo ST_Geometry;
    
    set geo = ST_Geometry::ST_GeomFromText( wkt, srid );
    RETURN CAST( geo AS ST_Polygon);
END

Note

The ST_PolyFromText function is not present by default in newly created databases. Use the sa_install_feature system procedure to install the spatial SQL compatibility functions. See sa_install_feature system procedure.

Standards and compatibility

Discuter à propos de cette page dans DocCommentXchange.