ST_GEOGFROMWKB

Updated at:

ST_GEOGFROMWKB converts WKB-formatted BINARY data into a geography object.

Syntax

GEOGRAPHY ST_GEOGFROMWKB(BINARY <WKB>)

Parameters

WKB: Required. WKB-formatted BINARY data.

Return value

Returns a geography object. The output may differ slightly from the input due to precision limitations in the S2 geography library.

Examples

SELECT ST_GEOGFROMWKB(x'000000000140000000000000004010000000000000');
-- Returns:
+-------------+
| _c0         |
+-------------+
| POINT (2 4) |
+-------------+

Related topics