ST_GeomFromWKB function [Spatial]

[DBO.]ST_GeomFromWKB(wkb[, srid])

Name	Type	Description
wkb	LONG BINARY	The WKB representation.
srid	INT	The SRID of the result. If not specified, the default is 0.

ST_Geometry Returns an ST_Geometry value created from the input string.
The spatial reference system identifier of the result is the given by parameter srid.

The ST_GeomFromWKB function is equivalent to the following:

CREATE FUNCTION DBO.ST_GeomFromWKB( wkb LONG BINARY, srid INT DEFAULT 0 )
RETURNS ST_Geometry
BEGIN
    DECLARE geo ST_Geometry;
    
    set geo = ST_Geometry::ST_GeomFromWKB( wkb, srid );
    RETURN CAST( geo AS ST_Geometry);
END

Note

The ST_GeomFromWKB 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.

ST_GeomFromWKB method for type ST_Geometry

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

ST_GeomFromWKB function [Spatial]

Syntax

Parameters

Returns

Remarks

Note

See also

Standards and compatibility