Apache Pinot Docs
latest
Search…
⌃K

ST_GeogFromWKB

This section contains reference documentation for the ST_GeogFromWKB function.
Returns a geography type object from WKB representation.

Signature

ST_GeogFromWKB(wkb)

Usage Examples

select STPOINT(-122, 37) AS point,
ST_GeogFromWKB(
ST_AsBinary(STPOINT(-122, 37))
) AS value
from ignoreMe
point
value
00c05e8000000000004042800000000000
80c05e8000000000004042800000000000
select STPOINT(-122, 37, 1) AS point,
ST_GeogFromWKB(
ST_AsBinary(STPOINT(-122, 37, 1))
) AS value
from ignoreMe
point
value
80c05e8000000000004042800000000000
80c05e8000000000004042800000000000
You can create geometry objects in the WKB format using the ST_AsBinary function.